How to Create a Straight table with Total Sales and Product Sales as Expressions?

[manozpph]

i want to create:-

Exp1: Total Sales: This expression should not change with any selection made in the ProductName list box. (Note: For any other list box selection besides ProductName list

box, this may still change).

Exp2: Product Sales: This expression should change with any selection made in the

ProductName list box.

Thanks in Advance!!!

[ashfaq_haseeb]

Hi,

Use below

Dimension.

ProductName

Expression 1

Sum({<ProductName=>}Sales)

Expression 2:

sum(Sales)

Regards

ASHFAQ