3 Replies Latest reply on Aug 16, 2018 10:53 AM by varun kalra

    Measure by Total Average

    varun kalra

      Hi There

       

      I am trying to calculate an additional column "index" which should be calculated as LTV by product / Grand Total Avg. of the LTV (all products combined) .

       

      For eg. index for A should be 34.82/94.47

       

      Tried using the LOD but not getting desired result :

       

      SUM([LTV])/AVG({ FIXED [Product]:SUM(LTV)})

       

      Please guide.

       

      Thanks

       

      Veekay