Time Filter Based on Versions

aishabhy05
Contributor

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.

 

aishabhy05_0-1628788827731.png

 

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

5 REPLIES 5
rob_marshall
Moderator

Re: Time Filter Based on Versions

@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
Contributor

Re: Time Filter Based on Versions

@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
Moderator

Re: Time Filter Based on Versions

@aishabhy05 

 

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

 

2021-08-13_07-47-13.png

aishabhy05
Contributor

Re: Time Filter Based on Versions

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

aishabhy05_0-1628859661037.png

Version is customised version ( Not anaplan Standard version) 

 

aishabhy05_1-1628859803965.png

 

Thanks,

Aish

rob_marshall
Moderator

Re: Time Filter Based on Versions

@aishabhy05 

 

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

 

 

2021-08-13_08-20-42.png2021-08-13_08-20-56.png