Is there a way to make dynamic labels for pivot table columns?

[kepiluna2]

I have a pivot table that displays monthly quantities in transit, outstanding po quantities, demand, and inventory ending position. I need the labels to be dynamic and be a rolling calendar. So this month is July I want to see August through January, next month it should be September through February. The problem is i set the label to be a formula such as =month(today()) for the current month, but now I have to write that formula each time I need to reference that expression in another expression. Is there any work around?

[Gabriel]

Hi,

Create a variable and give the definition of the variable as the formula, then you can reference the variable anywhere you want to use the formula, see below.

LET vCurrMonth = MONTH(TODAY());

Hope it helps

[Brett_Bleess]

Check the following Design Blog post too, might be another avenue to pursue:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Regards,
Brett