Pivot Label Calculation Problem

[Anil_Babu_Samineni]

Hello,

I've created one variable like

vCurrMonth = Max(Month(Today())-2)

And i've create object. I want to show Label like Actual(Jul) --

In future, we change the variable like =Max(Month(Today())-1) -- I want label like Actual(Aug) -- Like that

I've attempt this

='Actual' & chr(32) & '(' & Date#(Max(Month(Today())-2),'MMM') & ')'

It is giving Actual(7) -- I want Actual (Jul)

Can anyone assist me?

[settu_periasamy]

Have you tried this?

='Actual' & chr(32) & '(' & Date(Date#(Max(Month(Today())-2),'MMM'),'MMM') & ')'

or

='Actual' & chr(32) & '(' & Date(Max(Month(Today())-2),'MMM') & ')'

[vishsaggi]

Did you try this:

vCurrentMonth = Max(MonthName(Today())-2)

='Actual' & chr(32) & '(' & Month(Max(MonthName(Today())-2)) & ')'

[Anil_Babu_Samineni]

Settu,

I've done these while i have the calculated variable,

But what i did is - I've created one static variable like vCurrMonth = 7

Expression is this.

='Actual' & chr(32) & '(' & $(vCurrentMonth) & ')'

Label showing like Actual (7) - I want to show 7 instead of Jul. Does it possible?

[settu_periasamy · Accepted solution]

Ok. then try like this..

='Actual' & chr(32) & '(' & Date(Date#($(vCurrentMonth),'M'),'MMM') & ')'

[Anil_Babu_Samineni]

Rocking