combine values in an "others" colum

[btrompetter]

Hello,

I want to create a pivot table which has a dimension called partner. But it should only show the best 9 partners and combine the rest in a column called others if there more than 9 partner.

Is this possbile and how must I create this calculated dimension?

regards

Bastian

[#2 · Accepted solution]

Hi,

see the attached example. Hope it helps.

Good luck!

Rainer