How to calculate sales excluding Group no specified in other field

[david_ze]

Hi all,

I have two table

1. Agent NO, Year, Month, Target, ex_Group

2. Agent NO, Sales_Year, Sales_Month, Amount, Product_Group

I would like to calculate all sales for each agent excluding the sales for Product_Group number specified within ex_Group.

Will appreciate your advise on how to do this either in the script or using set analysis.

Regards,

David

[tresesco]

Hi,

i think this simple expression should work(when your primary dimension in the reporting table is Agent NO 😞

Sum(IF(Product_Group<>ex_Group,Amount))

Regards, tresesco

[david_ze]

Thanks tresesco,

It's working right...

Regards,

David