1 of 1 people found this helpful
I took a look at your book - and understand you would like to just used the fixed total from one sheet on another - unfortunately that is not possible - the ranking functions are table calculations and work on the underlying table for an individual sheet -
as you can see below the subcategory rank in different years will vary - also the table calculations are after the Totals are determined
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.