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.
