3 Replies Latest reply on Dec 5, 2018 5:53 AM by Norbert Maijoor

# Rolling up 12 months YoY

Hi all,

I need your help to solve a problem. I am trying to build something similar to the graph you can see on the first screenshot and I have been trying lots of different ways to roll up the last 12 months for each bar but couldn't find the right way. The second and third screenshots are examples of the roll up I would like to have in the graph, for each bar a roll up of last 12 months.

You will find in the workbook attached a table calculation rolling up the last 12 months for the first bar but not for the other ones. Also note that the years 2014 and 2015 are hidden and in Order Date>default properties the fiscal year start date is October, the blue bar represent a roll up of last 12 months for the current year and the yellow bar for the previous year.

Samuel

• ###### 1. Re: Rolling up 12 months YoY

Hi Samuel!

Find my approach as reference below and stored in attached workbok version 10.3 located in the original thread

Rolling 12 month calculation: WINDOW_SUM(SUM([Sales]), -11,0)

Hope it helps,

Regards,

Norbert

1 of 1 people found this helpful
• ###### 2. Re: Rolling up 12 months YoY

Thank you so much Norbert! I used the calculation and compute using Order Date and it worked perfectly. I just have one more question. Is it possible to calculate the percentage difference between blue and yellow bars starting from this Rolling 12 months calculation?

• ###### 3. Re: Rolling up 12 months YoY

Hi Samuel,

You are welcome. Glad it worked out perfectly.

Hope it helps.

Regards,

Norbert