Adding expression after totals

[#1]

Hi!

I had a trouble with a pivot table. I had calculated totals (using partial sum). Now I want to add an expression 'Penetration' after totals column.But the problem is, since my columns were obtained by dragging rows to look like columns, this new expression (or column) appears after every column...

Is there any way to solve this? Right now , I have created another table only to show 'Penetration'. and have placed them together. But, this will give me problems if I want to export these tables as excel as I would want it in a single excel sheet..

Or alternately, is there any way I can combine two charts into one excel sheet?

Earlier, I had posted some questions for this same problem....I have mentioned the link below.

http://community.qlik.com/message/270290#270290..

Please scroll towards the end to see my questions.

Thanks ,

Anju

[#2]

Hi All,

We finally decided to go with an old version, where Penetration will appear after every column. This is a slight drawback , but it satisfies other parameters, and also trying to do anything more might just complicate things.

I am attaching  two versions of the report so that it might help somebody facing similar issues.

And a big thanks to Tom!!

Thanks and Regards,

Anju