On the Medal Table, right click on Rank on the rows shelf and select Edit Table Calculation... Then, choose Advanced under the Compute using drop down. In the Addressing box, place COUNTRY then TOTAL. Click OK. Set At the level to Deepest and Restarting every to None. Click OK.
Hope this helps!
I have a ranking problem also, and would be really grateful for your help please:
I'm trying to rank across three different measures (companies). When I select rank it ranks the column, not the row. I have tried to alter the ranking criteria, but I can only seem to get it to rank with in the selection, not between them.
How would I do this?
Would you be able to post the workbook?
Thank you very much for getting back to me.
Please find a mocked up version of my data in the attached.
What I'm trying to do is rank each company by the cheapest item it was selling in each store at each time. Example is a bit contrived, but hopefully you will follow!
I'm expecting an answer along the horizontal, but I keep getting answers on the vertical, or answers pertaining to the cheapest item that company is selling out of all the items that company is selling at that moment in time….
Ranking Question.twbx 18.8 KB
The biggest issue is that each company has it's own measure. Instead, you'll want to reshape your data so that each of the company names are in the same dimension. The following KB can provide a little more information on how to set up the data:
Thank you for replying Tracy.
Thank you for your help. It works for the ranking 1 to 4 to each year.
But the ranking doesn't match the rules that I put in the formula.
In 2011 GER must be second with the 7 gold and GBR third with 6.
In 2013, GBR should be first with 9 golds, then RUS and GER third.
If you choose only one year, the ranking will be good. A soon as you ask for 2 or more years it's getting false.
The ranking use the rule for the sum of medals on the 2 years because RUS get 16 and GBR get 15, GER 11 and FRA 8.
But for the placing there is no problem, the ranking is good for the two years. The placing point are not added on the two years and we have got a good ranking for each one.
Do you understand what I mean?
Hope my explanations are clear.
Thanks for your help again.