Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Based on the sample data shared, what would be the output you would expect to see?
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.
@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