2 Replies Latest reply on Nov 5, 2017 10:56 PM by Prajval T

Rolling 6 months  for each month.

Hi Team,

Is there any idea how to get the summation of measures for rolling 6 months on each month.

Means if have one year data like below. I need to show the latest 6 months rolling 6 months summation of data.

 Month of Order Date Profit Quantity Sales January ₹7,140 597 ₹43,971 February ₹1,614 363 ₹20,301 March ₹14,752 885 ₹58,872 April ₹933 733 ₹36,522 May ₹6,343 887 ₹44,261 June ₹8,223 931 ₹52,982 July ₹6,953 840 ₹45,264 August ₹9,041 884 ₹63,121 September ₹10,992 1,660 ₹87,867 October ₹9,275 1,133 ₹77,777 November ₹9,690 1,840 ₹1,18,448

Expected rolling 6 months data for recent 6 months.

PFA excel file, you will understand how rolling 6 months data should be calculated.

In the same way i need to get the result using tableau. and then i have to calculate Ratio.

Regards,

Prajwal

• 1. Re: Rolling 6 months  for each month.

There is a table calculation that will create your rolling 6 month totals - Just apply it to the sale, quantity. and profit

If you prefer to use a formula the formula is

The result is

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.

1 of 1 people found this helpful
• 2. Re: Rolling 6 months  for each month.

Hi Jim,

Thank you so much for the reply.

In the above post i have mention the values in the text to understand expected result.

But i need to display only the ratio on bar Graph. I understood that you have used table windows calculations but that wil not work with bar char.

for recent 6 months i need to show for every month rolling 6 moths data how i explained in the first post.

Do you have solution for this?

Regards,

Prajwal