Dynamic Naming in Custom Mode

[zhartman]

I would like the ability to have dynamic naming in custom mode so the name changes to match the period name. We are allowed to offset the period/months so they continuously shift, but you either have to always change the name or use some generic phrase such as -1 month instead of it pulling the name from the period that is set in the system.

[oliver.fleming]

Hey @zhartman

When naming your custom columns you can use {FDATE} and {TDATE} to dynamically update the headers.
{FDATE} represents the “from date” or start of the period and {TDATE} is the “to date” respectively.
See this thread for more details:

Dynamic Column Headers

Hi Tim, This is already supported in the product by using the {FDATE} and {TDATE} placeholders for the period captions. At runtime, these return the ‘From Date’ and ‘To Date’ of each period in MMM YYYYY format, like this; [image] If the custom column is using a range of offsets, you could have a dynamic caption by using “Sales {FDATE} to {TDATE}”, which would look like this at runtime; [image] This technique is covered in the documentation (in the section ‘Note about column names’); http…

Hope this helps!