Skip to Content
0
Former Member
Sep 21, 2005 at 03:02 AM

BPS: How to filter Lead Columns at run time

35 Views

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