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