Results 1 to 3 of 3

Pivot Table - Grand Total not the sum of the column

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2010
    Location
    Hong Kong
    MS-Off Ver
    2013
    Posts
    74

    Pivot Table - Grand Total not the sum of the column

    Hi

    In the attached file, Columns G & H in Tab PT are based on the formulae i created. i noted that in column H, the grand total (cell H28) is not the sum of that column.

    How can i rectify the problem? In fact, in my actual file, the sum of Column G is also out of line.

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1