This content has been marked as final. Show 8 replies
I want to sum the Volume who has Max Price group by Material Vendor combination and show in KPI
I have the following table
Expected Output in KPI .
For Material 1 and Vendor A the max price is 20 , so we have to consider 200 as Volume for that Material Vendor Combination
same goes for
Material 2 and Vendor 2 the max price is 50 , so we have to consider 400 as Volume for that Material Vendor Combination
So , in kpi the value should show 600
200 + 400 = 600
Can anyone help me in this ?
Thanks in Advance