Nprinting power point chart categories

[lomi89]

Hi Team,

I start with Nprinting, I am creating a Power Point report where I show different charts that have dates and measures dates like Year to Date.

When I create a column chart I can imput the measures but the categories title is not dynamic like Qlik Sense:

I tried with a Nprinting Formula or put in Excel the Formula but I don't give the good result. The dimension could be:

'YTD'&' '&month(monthstart(today())-1)&' '&year(today())

Thank you very much.