1 Reply Latest reply on Jul 2, 2018 7:15 AM by Rhishikesh Joshi

    Indexing using Sumproduct

    Rhishikesh Joshi

      Hi,

       

      Beginner in Tableau I am unable to calculate the Index. Attached is the data sheet and the desired output sheet in Excel

      I tried using Fixed function to aggregate fields at certain desired levels (TB, WD/WE and Activity Month) however am not able to achieve the correct result. I have successfully implemented this using Power Bi using Earlier Function and Weighted Average

       

      Some formulas that you might need:

      Avg ER = Revenue/FCT*10

      Index = Revenue/((Avg ER aggregated at TB, Activity Month and WD/WE)*FCT)*10*100

       

      Regards,

      Rhishikesh Joshi