In BPS manual layouts, data is displyed in a sorted format which is always in ascending order based on lead column characteristics.
Sometimes business scenario demands to display the data in a different order or based on a different characteristics. These particular scenarios are not handled by BPS layouts.
This blog will provide a simple solution for these kind of scenarios.
Step by Step Procedure
- Create a hierarchy on the characteristics which is present in lead column. Make sure the nodes should be in the order you want data to be displayed/sorted.
-
Create two different packages where one planning package will show default sorting order while second planning package will display data is an order required
-
Restrict the first planning package with the hierarcy that was created.
-
Check the output for two different planning package selections
-
Sort order with hierarchy restriction
-
Sort oder with default restriction
This shows that we can sort the Manual Layout display in an order required by business by creating a hierarchy variable.