Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i didnt get you exactly.. explain it
whether you trying to check overall total or sub total???
Sorry,I am trying to check the overall total,sub total is working fine.
thanks
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
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
thanks, i have already done that.sub total it is displaying correctly but main total is displaying wrongly.
in all fields where you use sum function write in expression
sum(total fieldname)
hope it helps you
i think you miss Total() function try it.
sum(Total(field))