Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

total for row and column

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

16 Replies
siddharth_s3
Partner - Creator II
Partner - Creator II

Sony,

This is very vague

soniasweety
Master
Master
Author

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

neelamsaroha157
Specialist II
Specialist II

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

lironbaram
Partner - Master III
Partner - Master III

hi

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

soniasweety
Master
Master
Author

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

soniasweety
Master
Master
Author

Hi

lironbaram can you explain me how it done?

how you got last column as total ?

neelamsaroha157
Specialist II
Specialist II

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

soniasweety
Master
Master
Author

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

Neelam Sehrawat

attached you can see

neelamsaroha157
Specialist II
Specialist II

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