This seems like a strange thing to do, but it's definitely possible. Instead of using quick table calculations, create the following calculated fields:
([Rank Profit]+[Rank Sales])/2
I'm using RANK_UNIQUE because that's the ranking method you were using in your table calculations, but there are other options. For more details, see the following: Table Calculation Functions
See attached workbook.
If this addresses your question, please be sure to mark this answer as correct. Thanks!
Count Rank.twbx 351.4 KB
I know how to do average rank across row, just like what you did.
However, what I am really looking for is average rank down the column. Do you have any idea of how to do it?
You'll want to do something line WINDOW_AVG([Rank Sales]). This will create a table calculation and you'll have to set up that table calculation to work the way you need it to.
Can you give an example of how this should work using the data in your workbook?
Basically, I want to have a row in the very bottom (after Wyoming) saying the average rank of Sale and average rank of Profit in the workbook I provided.
If you confused about the original workbook, I have posted another one to better demonstrate what I need to do.
In this workbook, I want to calculate a average rank since 2000 for each region. It should look like "grand total", however, grand total does not calculate the right number and the "average" in grand total does not work either.
I am thinking about just calculate an average rank number in a separated worksheet and combine later in a dashboard.
Any help will be appreciated!
Average rank.twbx 472.0 KB