Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table by accounts and quarters across the top.
I need to create a view that has the current quarter only, so I have used this expression:
=
if([Fiscal Quarter]='2015-4',sum([USD Product Bookings]),'0')
Now, I want to sort, the values in descending order, but I am unable to. I tried Sort - Expression - Descending - =if([Fiscal Quarter]='2015-4',sum([USD Product Bookings]),'0')
but it did not work.
Thanks for your help.
Have you tried sort by Y value?
-Rob
Thank you, Rob
HI Use the expression like
Sum(if([Fiscal Quarter]='2015-4',[USD Product Bookings],'0') )