YTD sales quarter wise

[Anonymous]

Hi All,

I have two years 2016 and 2017 sales. We are using master calendar. 2016 quarter wise sales to be compared with 2017 YTD sales quarter wise.

i.e

Q12016 is (Jan feb Mar), Q22016 (Apr May Jun), Q32016 (Jul Aug Sep) and Q42016 (Oct Nov Dec) of 2016.

But

Q12017 is Jan feb Mar, Q22017 (Jan feb Mar Apr May Jun), Q32017 (Jan feb Mar Apr May Jun Jul Aug Sep) and Q42017 is (Jan feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec) of 2017.

Regards,

Krishna

[vinieme12]

refer this post,

Calculating rolling n-period totals, averages or other aggregations

the same concept can be used on the Quarters dimension

[Anonymous]

Hi Vineeth,

This comparison required to be on stack bar chart. Below is sample image which was created in Ms office excel.