Please find the attached excel sheet. I have Products from P1 to P8.
When i select P1,P4,P5,P6 from Product Filter, NEW ASP(ASP * GROWTH) should get changed based on the Product filters we select and for filters which was not selected ASP should remains the same.
Product Filter should get applied to New ASP but not to ASP. ASP Should remains the same. When we select Products from Product Filter, New ASP should get displayed as Above based on ASP and Growth Parameter selection.
Please help me out.
Norbert Maijoor Please help me on this. I will be deleting previous Forum.it was created my mistake.
In simpler way i Need below logic:
New ASP should be : (selected product value * %) + non-selected product value