Only show a product if a specific Manufacturer has that product

[Anonymous]

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:

Product          Manufacturer          Sales

A                         1                                5       

A                         2                               10

A                         3                               15

Is there an expression I can use to do this?

[swuehl]

Create a straight table with dimensions Product and Manufacturer, then use this as expression:

=sum({<Product=p(), Manufacturer=>}Sales)

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:

=sum({<Product=p({<Manufacturer={1}>}), Manufacturer=>}Sales)

Hope this helps,

Stefan

[#3]

Hi

You can use formula in Dimension itself.

Plz refer to attachment.