I have a table with:
Product Manufacturer Sales
A 1 5
A 2 10
A 3 15
B 2 20
B 3 25
I only want products to show where Manufacturer = 1, but I still want to see the sales for the other Manufacturers that sell that product.
So the above table would be reduced to show the following:
Is there an expression I can use to do this?
Create a straight table with dimensions Product and Manufacturer, then use this as expression:
If you now select Manufacturer 1, you should get your result (works also with selecting any other Manufacturer).
If you want to set Manufacturer to 1 without selecting in that field, use:
Hope this helps,
You can use formula in Dimension itself.
Plz refer to attachment.