3 Replies Latest reply on Nov 6, 2018 5:03 AM by Jim Dehner

    Calculated field for Sum of next 6 months

    Ranga Reddy  P

      Hi,

       

      I'm very new to tableau, I've started developing some simple dashboards. I got a requirement to calculate the sum amount for next 6 months and display it on the current month.

       

      For example:

       

      I've a graph as shown below, where i am showing quantity and sales with dual axis, but my requirement is to calculate the sales amount from Jan 2014-Jun 2014 and divide it with the Jan 2014 Quantity and show it.

       

      For Feb 2014, i need to calculate Feb 2014 - Jul 2014 and divide it with the Feb 2014 Quantity. So on....

       

       

       

       

      Regards

      Reddy