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

# Calculated field for Sum of next 6 months

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

• ###### 1. Re: Calculated field for Sum of next 6 months

Good morning

see the attached

The calculation for the next 6 months sales is done with window_sum

then divide by the current sales

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Calculated field for Sum of next 6 months

It Worked and thanks a ton.