month year

[upaliwije]

Hi Friends

I have following Month_Year field in QV pivot table

Month_Year

Apr-2019

Feb-2019

Mar-2019

May-2019

I want to make a calculation in my expression. I have written below one 

SUM({<num(Month_Year)={"<=$(=MAX(num(Month_Year)))"}>}PROV_AMOUNT)

But It does not work. Kindly help me to correct it 

[Shubham_Deshmukh · Accepted solution]

Hey @upaliwije ,

I won't work like this, take max of date from which you created Month_Year combo.

SUM({<dates={"<=$(=MAX(dates))"}>}PROV_AMOUNT)

Try this

Rgds,

Shubham

[Brett_Bleess]

Did Subham's post help you get things resolved?  If so, please be sure to click the Accept as Solution button for them to give them credit for the assistance.  If not, let us know where things stand.  I also left you some links on the other post you had regarding the same issue as well.

You should keep things on a single thread by the way versus opening new threads...

Regards,
Brett