10 Replies Latest reply: Nov 21, 2015 7:24 AM by Hirish V RSS

    Final Total In Pivot

    Hirish V

      Hi all,

       

       

      Here in the Attached Pivot table ,

       

      I required to calucualte Final Performance Line,

       

      It should be , at

       

      Dimensionality=1,

       

      CLP *  Performace

       

      Dimesionality =0,

       

      Total of that above line .


      But,when i  select each states it should give relative individual Percentages.

       

      Pivot Fperf.PNG

      PFA,

       

      Thanks in advance,

      Hirish