Custom Sorting In Pivot Table:
We have order status and the total order amount. The requirement is to show the order amount across the three different order status:
1.Booked
2.Cancelled
3.Closed
User wants the order status to be sorted in the report as below:
1.Closed
2.Cancelled
3.Booked
By default, obiee would sort the values in the alphabetical order. Generally sorting is applied from left to right, therefore the column for which custom sorting has to be applied should be placed in the left. Status is sorted using sort column in which the sorting order is defined and it should be placed in the left side.
Order status and total order amount result
We have order status and the total order amount. The requirement is to show the order amount across the three different order status:
1.Booked
2.Cancelled
3.Closed
User wants the order status to be sorted in the report as below:
1.Closed
2.Cancelled
3.Booked
By default, obiee would sort the values in the alphabetical order. Generally sorting is applied from left to right, therefore the column for which custom sorting has to be applied should be placed in the left. Status is sorted using sort column in which the sorting order is defined and it should be placed in the left side.
Order status and total order amount result
add sort column at the last and without applying sort-check criteria
Pivot Table:
