How to filter a grid using the composite list?
Subsidiary is the composite list here as an example, i want to filter my grids based on the selection at any levels.
For E.g If i select RoW then i should be able to see all the data of Germany, Brazil, Australia etc.
Answers
-
@araj - Turn on the native hierarchy filter & you should be able to select that in the context selector & filter the grids.
If not, creating a parallel flat list with all members & creating the filters would be the way to go.0 -
@devrathahuja My grid has flat list as a dimension. Subsidiary details are in line items. So we cannot keep it in the context selector.
Also, we don't want to create a separate list; we want to achieve this using the composite list.
0 -
@araj - If you do not want to create a separate list, you'd have to publish the list (shown in the screenshot) as 2 separate filter fields. 1 with the parents, 1 with the children, either as 2 field cards or just 2 grids with boolean to filter the below grid.
0 -
@devrathahuja Thanks for your time and effort. My current setup is in a similar way by having different fields of levels, but I wanted to check if we could achieve this using a single field.
0
