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

    Calculated field for Sum of next 6 months




      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....