Hi,
Is it possible to implement a sort order on a column/field based on another field from the data source? For example, I have a 'Product Category' field which needs to be sorted based on another field 'Sort_Id' from the same database table. One approach I have in mind is to create a database view of the table and implement the sort order on the view itself so that I can use 'data soure order' to sort the results. Any suggestions?
thanks,
Swapnil
10 answers
Hi,
Follow the below steps to sort the dimension on another measure.
1.Right click on dimension and select sort.
2) Select sort order
3)Select field measure from the drop down to sort.
Regards
Bhujang
