1 Reply Latest reply on Jan 25, 2019 8:12 AM by Jim Dehner

    Trend to compare based on current year top values

    Amar Amar

      Please find the attached workbook for the issue i'm facing and looking for an answer. Please advice.

        • 1. Re: Trend to compare based on current year top values
          Jim Dehner

          Hi

          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

           

          Jim

           

          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.

          1 of 1 people found this helpful