Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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