Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

I need to add rows in pivot table,

I need to add rows in pivot table, as follows:

Sales 100

Sales2 200

total Sales 300

Costos 100

total Costos 100

benefit total:200

please help

2 Replies
gussfish
Contributor II

Re: I need to add rows in pivot table,

I think you're asking how to including subtotals and totals in your

pivot table.

Bring up your pivot table's properties and go to the Presentation tab.

Select your dimension fields. Just under the list of fields is a

checkbox 'Show partial sums'; tick that checkbox and press OK.

Have fun!

"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."

Not applicable

I need to add rows in pivot table,

If we agree, but all labels bearing the same name.
Matter is not so in real life, subtotals usually have
different description.

please help