Mix Total In A Multi Level Pivot Table

[#1]

HI All,

I think this is one of those.. should be easy kind of things.

If you can look at the picture please...

http://tinypic.com/r/vfghow/6

I am trying to get the mix column to add up to 100 % at the 'br' level..

so my 1st highlighted total line would be.. 17 ... 100% (& not 7% currently) with the 3 rows above it adding up to that 100%

I can get it to total based on the 1st column or the 2nd column on their own, but not the two combined 😞

Any help greatly appreciated

Thanks

Bob

[#2]

Hi Bob,

would you please so kind and provide sample data.

Thank you.

Rainer

[#3]

With the new forum I cannot see how you add attachments - any ideas please?

[#4]

Hi Bob,

if you REPLY than go to Options tab and you will find ADD/UPDATE (File attachmend).

Rainer

[#5]

Thanks Rainer - now attached

[#6 · Accepted solution]

Hi Bob,

see if we are a step forward.

Rainer

[#7]

HI Rainer,

Thanks - that's it... tried all sorts of weird brackets etc.

Thank you so much!

Bob