1 Reply Latest reply on Jun 19, 2015 5:30 AM by asim cholas

    Totals for Pivot View Repsort

    894108

      Hi All,

      I have report that is sub totalled for two dimensions.

       

      Eg

      Dim1          Dim2      Metric1      Mertic2      Metric3(Metric1/Metric2)

       

      abc               efg          100          20               5

      dffd               vew          200          10              20

                          Totals     300          30               10(should be 25,col total)

       

       

      How do i get the correct value in pivot for the calculated (metric col).I have tried unchecking report based totals didn't work.

       

      Any workaround?

       

      Regards,

      Sri