Totals in Pivottable splitted by second dimension

[peterwh]

Hello,

I've searched the forum and didn't find any solution:

I have a pivottable and I need the totals splitted by the second dimension. How can I achieve this?

Attached is an example how the table should look like.

Kind regards and thanks in advance
PeterH

[#2]

HI, did you find any solution for this problem??

[peterwh]

Hello,

as you can see nobody has answered my question, so it is still a problem. I have only a workaround: I have a second table on the sheet where I deleted the "Productionline" dimension. But this is not what the users want, since they had one Cognos Powerplay list they exported into Excel, now they have to export two lists and the "real life" example is not as simple as my example.

So if anyone has a solution for my problem, please answer.

Kind regards
PeterH