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
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
