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.