8 Replies Latest reply: Jan 22, 2016 6:14 AM by ajay singh RSS

    Pivot table sorting

    Priya R

      Hi Community,

       

      I wanted to perform sorting based on for ex; Sum(sales) - first expression in my pivot table and other too.

       

       

      I have 4 calculated dimensions like

      1. =if(IRB_WR_Type = 'Wholesale' ,if(isnull(IRB_Category),'CRR Unallocated',IRB_Category)) as Dim1

      2. =if(IRB_WR_Type = 'Wholesale',if(IRB_Band = 'CRR_U',' ',IRB_Band)) as Dim2

      3. =if(Match(IRB_Band,'CRR_U') > 0,' ',Num((IRB_Lower_Band*100),0.000)&'%') as Dim3

      4. =if(Match(IRB_Band,'CRR_U') > 0,' ',Num((IRB_Higher_Band*100),0.000)&'%') as Dim4

       

      How can I achieve this