I'm new to set analysis. I'm trying to develop a table which will provide a breakdown of our rebate owed per product line. My problem is that the rebate on each product line is based on a different %.
For Example:
If my Category (Product Line) contains Product Line 1, Product Line 2,Product Line 3, etc., and I want to multiply these lines by 5%, 10% and 15% respectively, how could I create something similar to below:
Product Line: Net Sales Rebate Owed
Product Line 1 10,000 500
Product Line 2 20,000 2,000
Product Line 3 5,000 750
Would I need a different expression for each product line? I've tried something like =Sum(<[Product Line]={[Product 1]}> [Net Sales])*.05 but it hasnt gotten me anywhere. Any help would be appreciated.
