I Want To Create the Bar Graph for Last Two Years Sales by category

Anonymous — Fri, 13 Oct 2017 14:13:12 GMT

Please find the below sample Data,

I want to Show the last two years sales is bar Graph for 2016 & 2015 based on category

I have used the Set Expression as :Sum({<Year={$(=Max(Year))}>}SalesValue) and Sum({<Year={$(=Max(Year)-1)}>}SalesValue)

but this expression is not working

Kindly help me out

Thanks in Advance!!

Re: I Want To Create the Bar Graph for Last Two Years Sales by category

MarcoWedel — Tue, 17 Oct 2017 20:18:45 GMT

Hi,

your expressions should work, here one example:

Another solution might be to add a Year dimension and use only one expression like this:

hope this helps

regards

Marco