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