Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi Jonathan
This is my Formula: Sum ({<Year={$(VmaxYear)}>} ([Sales]))
Can I add another selection?
Brilliant! Thank you!
Jan,
Yes you can, i guess you already do it but there you have:
Sum ({<Year={$(VmaxYear)}, [Business Unit] = {'Unit 1'} >} ([Sales]))
Regards!