I need to know if there is a way to filter values for lead columns, after planning level and planning package where defined
Example:
Family | Material | Brand | Format | sales | cost | Margin
F1 M1 B1 F1 100 80 20
F1 M2 B1 F1 95 85 10
F1 M2 B1 F2 105 90 15
In this case the user wants to add 10% to sales and review how does it impact into margin, but he wants to apply it only to rows where Material is M1.
So, he needs to use some kind of filter data (like Excel functionality) to select only the rows corresponding to material M1.
After that, he wants to perform other filters over the other lead columns, and apply again some changes in the data columns.
Somebody can help me with this requirement?
Thanks in advance
Message was edited by: Pamela Valdivia