• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum values in Pivot table is not correct

M

MBS

Member
Hi all,
Please let me know , why calculated value of sum field in pivot table is not correct, where as grand total is correct. What can be possible causes.

78039
 
MBS
Is Your calculation correct?
Based Your given snapshot, there are challenges to get clear image of Your thread.
Could You send a sample Excel-file?
 
Hi,
I have attached the file.
 

Attachments

  • Sapmple Pivot_Sum Error_File.xlsx
    357.5 KB · Views: 7
MBS
Sheet1 has something else than Pivot-table.
... with Pivot-table it could get something like below without any calculated fields.
Screenshot 2022-03-12 at 14.55.23.png
 
You must log in or register to reply here.
Back
Top