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

    Show category with highest sum

    jon.baker

      Hi,

       

      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:

      eg1.png

       

      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:

      Picture1.png

       

      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

       

      Thanks,

      Jon