Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
refer this post,
Calculating rolling n-period totals, averages or other aggregations
the same concept can be used on the Quarters dimension
Hi Vineeth,
This comparison required to be on stack bar chart. Below is sample image which was created in Ms office excel.