Problem in finding the total

[techvarun]

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.

[techvarun]

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

Thanks in Advance

[alexandros17]

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

hope it helps

[#4]

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

[techvarun]

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

[#6]

try this

sum( Fieldname)

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

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

or try this

sum(total Fieldname)

[techvarun]

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

Regards

[techvarun]

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

Regards

[alexandros17]

add this expression

aggr(sum(Fieldname), year, quarter)

[alexandros17]

add this expression

aggr(sum(Fieldname), year, quarter)