How to compute sum(sales) when user click on Diamension = Coy ?

[paulyeo11]

Hi All

I have Table 1 , it can display correct report when user click on Diamension = Brand , Product Class , Desc .

But when user click on Diamension = Coy , Table 1 display wrong report.

So when user click on Company , i want to table 2 data display at Table 1.

I try the expression below :-

if(

$(ColumnDim10)

='5 COY'

,SUM(sales)

,SUM(C_ONHAND_AMT)

))

it display null value.

Paul

[gautik92]

can yu send sample qvw?

[paulyeo11]

Hi All

Enclosed my QV doc.

Paul