Limit dimension in table

[#1]

Hi experts

I have the folowing prpblem:

I created a table. The dimension is Business Unit. With the formula I sum up the sales. I have 2 Units, Unit 1 and Unit 2.

How can I restrict the Dimension that only Unit 1 is displayed in the table?

Thank you for your help!

Jan

[#2 · Accepted solution]

in the set analysis expression, do something like : =sum({$< [Business Unit] = {'Unit 1'} >} Sales)

Hope it helps!

If this is what you looking for, remember to mark as answered!

Best regards!

Jonathan.

[#3]

Hi Jonathan

This is my Formula: Sum ({<Year={$(VmaxYear)}>} ([Sales]))

Can I add another selection?

[#4]

Brilliant! Thank you!

[#5]

Jan,

Yes you can, i guess you already do it but there you have:

Sum ({<Year={$(VmaxYear)}, [Business Unit] = {'Unit 1'} >} ([Sales]))

Regards!