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.