Set analysis for Filters

[Raggs]

Hello Team,

I have a data as below,  I need the output as % Values calculate on sales based on the Filter type only.

example: A = Allowance, V=Incentive, M=Margin 

Filter Type	%Values
A	2.00
A	1.30
V	0.56
A	5.00
V	6.00
M	4.30
V	2.40
M	8.50
A	10.00

Can you please help me on this with set analysis.

Thanks in advance.

[sunny_talwar]

Based on the sample data shared, what would be the output you would expect to see?

[Raggs]

Hello Sunny, 

Please find the below table for your reference

Filter Type	Item#	%Values	Sales Value	Allowance	Incentive	Margin
A	1235-5	2.00	1000	Here we need to calculate the Allowance % on particular Item sales and That calculated value should reflect here	Here we need to calculate the Allowance % on particular Item sales and That calculated value should reflect here	Here we need to calculate the Allowance % on particular Item sales and That calculated value should reflect here
A	1236-7	1.30	1500
V	1235-6	0.56	2000
A	1236-8	5.00	2500
V	1235-7	6.00	3000
M	1236-9	4.30	3500
V	1235-8	2.40	4000
M	1236-10	8.50	4500
A	1235-9	10.00	5000

Thanks in advance.

[Brett_Bleess]

@sunny_talwar Poster came back with expected output, am guessing we may still be having notification issues in Community, sorry about that, if you have time to have another look at things, much appreciated.

Regards,
Brett