How to an expression that is based on a conditional dimension?

[chiranjivdas]

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.

[rwunderlich · Accepted solution]

Have you tried sort by Y value?

-Rob

[chiranjivdas]

Thank you, Rob

[Anonymous]

HI Use the expression like

Sum(if([Fiscal Quarter]='2015-4',[USD Product Bookings],'0') )