Sort calc in Pivot table by lastest quarter

[#1]

Hello,

I am trying to get the ‘Pivot
table Chart’ to sort the Revenue in descending order by the current quarter or
oldest quarter which happens to be= 20144?

But the calc. I have below is
sorting the total of ‘all quarters’ in descending order? How can I get it to
sort the latest quarter without specifying the quarter name= 20144?

Current calc. in the ‘Sort’ Tab

=if(Curr_Qtr_Flag='Y',SUM(Value)*13/wknuminCQ,SUM(Value))/1000

As you can see I am repeating the calculation I am using to Project revenue in the current quarter. I am trying to Sort the current qtr column. I have attached the .qvw

Thank-you in advance for your help!

Diane

Message was edited by: Diane Anemoduris added QVW