stacked chart dimension limits

[#1]

Hello all,

I'm creating a stacked chart that should result into 100%.

this works as you can see below. (I had to pick these ugly colors)

Now there question is to only show CR and CN and group the rest in Others.

I made a sorting which puts these two first and then I used dimension limits to show only first 3.

But some months there is no CN or CR so in those cases other types are popping up. Which I don't want.

I only want to show CN and CR and always the rest on Others. could someone help me with this?

[#2]

anyone?

[Gysbert_Wassenaar · Accepted solution]

Use a calculated dimension: =if(Match([Rejection Type],'CN','CR'),[Rejection Type],'Others')

[#4]

That's it. Now getting the sorting in order and it is finished. Thank you.