20 Replies Latest reply: Oct 26, 2012 2:25 AM by Anju Gopinath RSS

    Adding expression after totals

      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