0 Replies Latest reply on Jul 30, 2013 5:37 AM by Maik Schulthess

    Calculate Monthly Weighted Value

    Maik Schulthess

      Hi !

       

      I am complete new user in tableau. Despite great presentations I got to do, I am totally lost when it comes to create calculated fields.

       

      Here is my issue. On a monthly basis, based on historical sales and promotion prices, I have to determine an Actual Selling Price to be compare with actual data. Find enclose the current calculation I did in Excel in blue.

       

      This is pretty straight forward in Excel but translating in tableau is quite a challange especially using date.

       

      I thank you already for all your great support

       

      Maik