Rank Function
1) Select the columns necessary
2) If you are ranking Revenue then select Revenue two times
1) Select the columns necessary
2) If you are ranking Revenue then select Revenue two times
3) Click on edit formula on the second measure
4) Select the rank function from the functions tab
Functionf(…) -> Aggregate data ->Rank
5) Select custom heading to customize your heading (changing name of the column)
Click close once selected
6) Click on the measure again in the selected criteria and sort ascending.
Result:
No comments:
Post a Comment