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: 
techvarun
Specialist II
Specialist II

Problem in finding the total

Hi all

                   I have a pivot table with year quarter and month i have computed total profit for monthwise and i need to show the total of all the three month value in last column.

1 Solution

Accepted Solutions
nizamsha
Specialist II
Specialist II

see the attachment

View solution in original post

14 Replies
techvarun
Specialist II
Specialist II
Author

I need to show the sum of total of month April+May+June in last Column


Thanks in Advance

alexandros17
Partner - Champion III
Partner - Champion III

IN presentation check (near fields list) the field for which you need the sum ... (show partial sum)

hope it helps

Not applicable

Presentation TAB >select Month ---check show partial Sums

techvarun
Specialist II
Specialist II
Author

the total field is a calculated field and i need the sum of all three months also a calculated field

Not applicable

try this

sum( Fieldname)

and in presentation tab select the field month then check show partial  sum.

******************************************************************

or try this

sum(total Fieldname)

techvarun
Specialist II
Specialist II
Author

am getting partial sum but i need the value as a separate column in the end of the table


Regards

techvarun
Specialist II
Specialist II
Author

am getting partial sum but i need the value as a separate column in the end of the table


Regards

alexandros17
Partner - Champion III
Partner - Champion III

add this expression

aggr(sum(Fieldname), year, quarter)

alexandros17
Partner - Champion III
Partner - Champion III

add this expression

aggr(sum(Fieldname), year, quarter)