Dynamically filtering line items based on version selected on the page selector

We are looking to filter the line items shown on the dashboard as per each version that is selected by the user. We have built a model for P&L Target Setting wherein different stages of the process are included as versions. There are different line items which are relevant for the various versions according to the process stage we are on. So, what is happening currently is we are having to build different sets of dashboards for all these different versions.

I was wondering whether there was a way to filter the line items displayed on the dashboard according to the each selected version.

Accepted answers

All comments

DavidSmith

@saurabh.raheja

You can easily achieve this with a Line Item Subset (assuming all of the metrics are numeric)

1. Let's assume I have the follolwing module, dimensioned by Customer and Version, with four line items: Sales, Volume, Expenses and Costs

2. Create a line item subset from that module and include all applicable line items (Note the Best Practice naming convention (Module:Line Item Subset Description)

3. Create a module dimensioned by Version and the Line Item Subset, with a single Boolean line item and check the appropriate combinations

4. In the target module, set the filter to the line item from above

5. Viola!!

If your P&L Module had the metrics in a list rather than line items, you can skip step 2.

I hope this helps

Happy modelling

David

saurabh.raheja

Thanks @DavidSmith for such a detailed explanation. This really helped us!

MadhabikaM

Hi David,

Thanks for the above suggestions, it works fine but does this take care of a 'Text' formatted line item as well? because while trying this,I could not choose
(a 'text' formatted line item ,its disabled)in the Subset view.

saurabh.raheja

Hi @MadhabikaM

You can only choose Number formatted line items in a Line Item subset. So this solution does not work for text-formatted line items.

Saurabh

MadhabikaM

Thanks for your Quick response Saurabh.
So I am trying here to filter few line item based on version selected, so is there any way to do this?
I don't want this text formatted line item to be considered but this needs to be viewed in the dashboard, and this process above is stopping me to do so.

DavidSmith

The only way is to have the text line items in another grid (below or to the side), that is shown all of the time regardless of the filtering

David

ryan_kohn

There is a related idea on the Idea Exchange. Please kudo and subcribe!

https://community.anaplan.com/discussion/33401/dynamically-filtering-the-line-items-columns-in-a-dashboard-table

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385