Nested LOD issue - calculate MAX at one level and then SUM at other levels.

Hi,

I am having trouble with my nested LOD expression. I have four dimensions in my data: Customer ID, Customer PO Number, Alternative, Line Item. I am trying to calculate the highest Alternative for each Customer PO Number, and then use these to calculate totals at higher levels.

Here is my process:

STEP 1 - I don't have data at Line Item granularity so I want to exclude this dimension and take a MAX to calculate total at each Alternative level.

STEP 2 - For each Customer PO Number calculate a MAX of all Alternatives.

STEP 3 - For Customer, calculate a SUM of those highest Alternatives. This is where I am failing, although my total is correct (714k), I lose detail on Alternatives level.

Am I missing something obvious?

Many thanks