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.
@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.
@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.
@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.
@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.
@araj , Hi if you could create separate line item, with the same or a lower list formatted, you could turn on dependent hierarchy from the format option by default & you can see the child items in second item based on the first line item
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…