This content has been marked as final. Show 2 replies
For the attached workbook, I created a simple ranking using the Index() function (calculated field called "Rank") as well as the running_sum of the minimum number of records (calculated field called "Ranking")
I am trying to rank the cities based on total sales. However, I want each bar to be color-coded by the category of sales. The intent is the overlap the data in the tab 'Correct Ranks' with 'Correct distribution', but I end up with the result in 'Incorrect ranks and distribution'.
Any help would be appreciated!