Hi,
Please can anyone show me how can I use a summary method but include only items that are visible after using a filter.
Thanks in advance
Hi @Ikrame
You would have to create another line item that shows filtered data only. You can use a formula like this - "If <filter condition> then <source data> else 0". Then the summary of the newly created line item will show you the sum of filtered items.
However, if your filtering is by user dimension, then this module will also need to be by user dimension and will tend to increase in size.
@Ikrame
Summary Items are applicable to all of the items, it doesn't work selectively or on filters.
Thanks,
Misbah
Miz Logix
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
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…
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.…
