Calculated dimension with multiple if's

[#1]

Hi all,

I have a question concerning calculated dimensions.

I have 2 dimensions:

1) type= A, B, C, D

2) number= 1, 2, 3, 4

I want to show types A, B and C, BUT for B I only want to show 1, 2 and 3.

So A and C can have all the numbers, but B can only show numbers 1, 2 and 3.

Thanks in advance!

Kind regards

[#2]

Awesome! I managed to find the correct calculated dimension

Thanks a bunch guys, much appreciated!