Display Native YTD and YTG with a filter

Hello Anaplaners,

I have an issue about displaying YTD and YTG in columns.

In a dashboard, i display a module with native time in columns. On this module, we set up a boolean dynamic filter linked to a time filter module. This filter displays the current year (2017 in this case). But the client needs YTD and YTG in the grid. I tried a lot of tips but it failed.

Does anyone know how to display dynamically YTD and YTG with a filter ?

Thanks for your help.

Jeremy

Accepted answers

PaulRitner

Hi Jeremy,

We can use formulas to ask what time period we are in (including summary time periods like YTD and YTG)... we just need to set the Summary setting for the line item to Formula. I've attached an example. Let me know if this is what you are looking for.

Cheers!

Paul

Time_Filter_Example_24232.docx

All comments

PaulRitner

Hi Jeremy,

Cheers!

Paul

Time_Filter_Example_24232.docx

Jeremy

Hi Paul,

Thanks for your answer !

Your solution allowed me to set up my dynamic filter. I didn't think to use NAME function.

Sincerely.

Jeremy

Marina Ketelslegers

Thank you,

Amazing how NAME (ITEM(Time)) is different from NAME (referring to another line item with ITEM(Time)).

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
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…
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.…