Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Partial sum in a pivot table

Hi,

Below is my pivot table, I have total in column for each SITE per TYPE I would like to also have my total in row for each REG per TYPE, this means to have the last column.splitted in 2 columns TYPE1 and TYPE2

Is it possible ? (file attached)

total Pivot table.jpg

Tags (3)
4 Replies
Siva_Sankar
Honored Contributor

Re: Partial sum in a pivot table

Hi,  Find the attachement. hope it helps.  Regards. Siva Sankar

Not applicable

Re: Partial sum in a pivot table

Thanks but I don't want to change the pivot, I want to keep my total per "Type" for each "Site" and add an other total per "Type" dor each "Reg" like this

total Pivot table2.jpg

Not applicable

Re: Partial sum in a pivot table

Hi,

I have attached the document, Hope it Helps.

Regards,

Kabilan K.

Not applicable

Re: Partial sum in a pivot table

Yes like this I have my total per "type" but it doesn't look like the presentation I really wanted

Community Browser