Combine Years to one Bar

[Lisa2]

Hello, I am creating a stacked bar chart, total cost of items by years where years is across the bottom.  I am only needing 5 years but I need that to show as only one bar, so combining everything in that 5 years and only showing one bar in the bar chart.  Right now I have, under the dimensions tab, YEAR and ITEM, and under the Expressions tab, I have the sum of the total cost of items.  I was thinking to make YEAR a calculated dimension but it is just not working for me.  It still separates all the years out. What do I need to do instead?

Thanks! 

[dplr-rn]

Do you want each bar will be an Item and stacks will be years?

Make sure you Item is above Year in the dimensions

[Lisa2]

One 5 year range bar with Items stacked.

[dplr-rn]

please elaborate what you are seeing woith a picture and how you want it

[Lisa2]

Stacked Items

[dplr-rn · Accepted solution]

Ok. so thats how you want to see it.

use a calculated dimension something like below

Min(total Year) & '-' & Max(total Year)