2 Replies Latest reply on Nov 10, 2013 9:30 AM by Ramon Martinez

    Ranking with a description legend

    Tandra Bidyananda

      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!