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

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…