Calculated dimension - group variables

[#1]

Hi all,

Small question concerning a chart.

I've got the table beneath:

The issue is the following:

I've got the dimension "type" with the values: 1, 2, 3, 4, 5, 6, 7, 8, 9

I used a calculated dimension to create what I've got now (basically split things up in 8 (=part 1) versus everything else (=part 2))

=if(match(Type,'8'),Type) and

=if(match(Type,'1','2','3','4','5','6','7','9'),Type)

*First problem: they are different calculated dimension so they show up in different columns. I need them in one calculated dimension and thus in one column.

*Second problem: I do not need them split up, I just want '8' and 'everything else'. I do not need to know the type behind 'everything else' (like 1, 4, 6, 7).

How do I fix my issue, without having to touch the codes?

Thanks in advance!

[m_woolf · Accepted solution]

=if(match(Type,'8'),Type,'Other')

[#3]

That did work, but something really weird is going on.

I just split everything up and the totals are not correct.

1+2+1+1 = 5? I just copied the bottom one and added the dimension "type" (~Artikelgroep)

This is really weird

[m_woolf]

Where are you seeing 1+2+1+1 ?

[#5]

On the right, where 4 is marked in yellow.

But I solved my own problem! Thanks