How to tabulate YoY sales with budget by given cut off month ?

Question

Summary

Content

Dear all,

Management want to have analytics with Year on Year comparison with a cut off month to compare sales revenue and budget.

I tried using presentation variable and

This is generated in BICS.  Due to same year, budget is stacked in same year and the group is with different color.  Anyone has experience to delivery such requirement ?

Please help.

Dorothy Teoh · Answer

Hi,

I did the mentioned steps to differentiate three measurement.  However, when sales and budget are in the same year, it will stack into one bar.  I want to display them in three separate bars with same products in same color; just like example in good old excel sheet.

Thanks, Dorothy

FTisiot · Answer

I suggest you to create 3 new measures:

1) Sales Prev Year with formula FILTER(Fact.Sales USING Dim Date.Year=2016)

2) Sales Curr Year with formula FILTER(Fact.Sales USING Dim Date.Year=2017)

3) Budget

and show the 3 in a bar chart