Tuple Dimensional Reporting

[cognos05]

Hi,

I have a crosstab where I have to show my core product and new product sale.


Rows                           Sales on core product      Sales on New Product

Distributor A                    444                                   64
Distributor B                    342                                   26
Distributor C                    232                                   55


Here my core products are a set of products and new products are set of products.

What should my data item expression for column1 i.e Sales on core product be .

I tried tuple(Product1, Sales).

My issue is I have a set of products defined under core products from different product level).

Suggestions on expression for core product sales if my core products has 3 products.

Thanks,
Nithya

[cognos05]

Used this one and got the result

Total(Sales within  set set(CoreProducts))

Thanks,
Nithya