stacked barchart 100%

[#1]

Hello,

I m trying to create a stacked barchart to present the composition of the sales. As you can see I'm using 2 dimensions [customer segment] & [product category].

If I don't check the relative box at the expressions properties I get the following chart, which is just fine.

The problem is that I want to have a 100% stacked barchart. So when I check the relative property, instead of getting 100% in all 4 bars, I get a 25% each.

Any ideas?

Thanks

Theodore

[#2 · Accepted solution]

Actually, I found the solution myself.

The relative property presents the share of the value in the whole chart, therefore it should be unchecked.

So, to have 100%, I simply went to the number properties, changed the format to number, and checked the show percentage.

It was easier than what I thought finally!