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

# Show category with highest sum

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: 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

Thanks,

Jon

• ###### 1. Re: Show category with highest sum

Ok I have solved this.

I created a calculated field called WINMAX CHECK with the formula SUM([Value])=WINDOW_MAX(SUM(Value)) and placed that on the filter shelf and set it to true.