Problem with the total option in pivot table

[#1]

hi,

       I am using pivot table for the UI,but the problem is total is not displaying correctly.plz help me to solve it

Thanks in advance

[er_mohit]

i didnt get you exactly.. explain it

whether you trying to check overall total or sub total???

[#3]

Sorry,I am trying to check the overall total,sub total is working fine.

thanks

[#4]

firstly  go to the dimension of pivote and select PARTIAL SUM   then go to the expression and write  sum(fieldname) then both total and sub total are displayed

hope it will help you

[er_mohit]

ok.

for this overall total which field you take as a dimension on chart with corresponding you want to check over aal total then you just see in attached image

hope this will help you

as in my image i hav  to check overall total correspong to mat _id

[#6]

thanks, i have already done that.sub total it is displaying correctly but main total is displaying wrongly.

[er_mohit]

in all fields where you use sum function write in expression

sum(total fieldname)

hope it helps you

[#8]

i think you miss Total() function try it.

sum(Total(field))