1 Reply Latest reply on Dec 14, 2016 6:02 PM by ranjit saha

    Working with wt avg - need help

    ranjit saha

      Hello,

      Am stuck up with a very silly issue and need some help in getting around it:

      Attached is the excel with the same date of the problem.

       

      Am calculating the savings in a product by comparing the unit prices of last year compared to that of this year(2016)

       

      1> First part of the problem is to get to the savings calculation - (Diff of Wt avg unit price of last year and this year * Qty this year)

      2> Next part would be compare the wt avg price with the last half year and not the entire full year.

       

      Need this urgently., am using 9.2 version of Tableau.

       

      Thanks