Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use a calculated dimension: =if(Match([Rejection Type],'CN','CR'),[Rejection Type],'Others')
anyone?
Use a calculated dimension: =if(Match([Rejection Type],'CN','CR'),[Rejection Type],'Others')
That's it. Now getting the sorting in order and it is finished. Thank you.