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
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…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
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.…
