topic Mix Total In A Multi Level Pivot Table in QlikView

Mix Total In A Multi Level Pivot Table

Thu, 03 Dec 2009 23:12:52 GMT

HI All,

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

If you can look at the picture please...

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

Fri, 04 Dec 2009 15:30:52 GMT

Hi Bob,

would you please so kind and provide sample data.

Thank you.

Rainer

Fri, 04 Dec 2009 16:11:46 GMT

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

Fri, 04 Dec 2009 16:27:20 GMT

Hi Bob,

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

Rainer

Fri, 04 Dec 2009 16:34:31 GMT

Thanks Rainer - now attached

Fri, 04 Dec 2009 17:12:07 GMT

Hi Bob,

see if we are a step forward.

Rainer

Fri, 04 Dec 2009 17:29:46 GMT

HI Rainer,

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

Thank you so much!

Bob