Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
soniasweety
Valued Contributor III

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

Tags (2)
16 Replies
Partner
Partner

Re: total for row and column

Sony,

This is very vague

soniasweety
Valued Contributor III

Re: total for row and column

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

neelamsaroha157
Valued Contributor II

Re: total for row and column

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

Partner
Partner

Re: total for row and column

hi

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

soniasweety
Valued Contributor III

Re: total for row and column

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

soniasweety
Valued Contributor III

Re: total for row and column

Hi

lironbaram can you explain me how it done?

how you got last column as total ?

neelamsaroha157
Valued Contributor II

Re: total for row and column

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

soniasweety
Valued Contributor III

Re: total for row and column

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

Neelam Sehrawat

attached you can see

neelamsaroha157
Valued Contributor II

Re: total for row and column

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