total for row and column

[soniasweety]

Hi all

Kaushik Solanki

Felip Drechsler

i want to achieve the grand total column for both    last row and last column  as grand total

i have attached sample and result

can anyone help me on this??

Thanks

Sony

[siddharth_s3]

Sony,

This is very vague

[soniasweety]

i want to show grand total  for  last row and last column  in qlikview pivot table

[neelamsaroha157]

What is the issue you are facing?? isn't turning on the partial sum for product and Quarter not working???

[lironbaram]

hi

look at the attach example isn't it what you are looking for

[soniasweety]

exactly.. what you have done?  i cant find the changes?

[soniasweety]

Hi

lironbaram can you explain me how it done?

how you got last column as total ?

[neelamsaroha157]

you just need to tick on the 'show partial sum' for the Quarter.

[soniasweety]

but if i have multiple measures  im getting multiple rows for total.

Neelam Sehrawat

attached you can see

[neelamsaroha157]

remove the 'Partial sum' for field 'Type'.