14 Replies Latest reply: Jul 22, 2013 4:07 AM by Nizam HM

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.

• Re: Problem in finding the total

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

• Re: Problem in finding the total

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

hope it helps

• Re: Problem in finding the total

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

Regards

• Re: Problem in finding the total

aggr(sum(Fieldname), year, quarter)

• Re: Problem in finding the total

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

• Re: Problem in finding the total

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

Regards

• Re: Problem in finding the total

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

• Re: Problem in finding the total

try this

sum( Fieldname)

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

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

or try this

sum(total Fieldname)

• Re: Problem in finding the total

aggr(sum(Fieldname), year, quarter)

• Re: Problem in finding the total

I have attached the qvw please check

• Re: Problem in finding the total

Hi techvarnun,

I've worked with your qvw, the result is that you must add the following expression (After Total):

aggr(NODISTINCT Sum({<Category={'Revenue'}>} [Exchange Rate]*[Total (Amount)]) - Sum({<Category={'Costs'}>} [Exchange Rate]*[Total (Amount)]) ,Category, Type, Year, Quarter)

This expression add a new column where all rows have total of quarter, if you need only one row with the total (but not a new row) delete NODISTINCT

Hope it helps

• Re: Problem in finding the total

see the attachment

• Re: Problem in finding the total

Sorry am on my qlikview personal edition

Regards

• Re: Problem in finding the total

IS that u want u want to add app+may+june and it should display in the next row

in presenttion enable show partical sums to month