Time Filter Based on Versions

Hi Team,

I have a scenario where I want to apply a filter on time (page selector) based on the Version which is also a page selector. I tried creating a time filter module and applied filter but it is not working.

Example:

If I select Forecast Version then the time page selector should show me FY21, FY22, FY23

If I select Budget Version then the time page selector should display FY 20

If I select Actual Version then the time page Selector should display FY19, FY20

Thanks,

Aish

Accepted answers

All comments

rob_marshall

@aishabhy05

What does your filter module look like? I would create a module dimensionalized by Version and Time (at the year level) with on line item named Show? which is a boolean. Then you can use that for your filter.

Rob

aishabhy05

@rob_marshall the filter module was by time(year) dimension and version and with display (boolean ) line item. The filter applies for only one version, however, I tried changing the summary methods yet it didn't work.

rob_marshall

@aishabhy05

Can you send a picture so we can get more information? I was thinking of this:

aishabhy05

@rob_marshall I tried the same filter, this is not working in UX Filter. If I select Result then

Version is customised version ( Not anaplan Standard version)

Thanks,

Aish

rob_marshall

@aishabhy05

I don't believe you will be able to do that, you will need to put Time in the grid.

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…