1 Reply Latest reply on Apr 16, 2013 9:16 AM by jon.baker

    Show category with highest sum




      I have some data that is arranged in a 3-level hierarchy: Version > Level 2 > Level 1.


      Version consist of 2 members, 1 and 2; Each member in 'Version' has 3 Level 2 members: A, B & C; Each of these has 4 level 1 members: Part 1 to Part 4.


      I would like to be able to show for each version, which Level 2 member has the highest sum across Level 1 members.


      For example, using the following data:



      I would like to return 99 for "Version" 1 (as the highest value of "Level 2" in "1" is 99, for "C") and 125 for version 2 (as A has the highest value, 125).

      The next step would then be to say which Level 2 member has the highest sum (e.g. C for version 1 and A for version 2).


      So my ideal output would be:



      Please can you let me know if it is possible to achieve this, and if so how?


      Example workbook is here: http://public.tableausoftware.com/views/TestWorkbook-Maxofsum/Sheet1?:embed=y&:display_count=no