Results 1 to 5 of 5

Pivot Table Won't Count Properly

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2010
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Smile Pivot Table Won't Count Properly

    Hi,

    I'm new here. I'm sure this is probably a rookie mistake, but I'm having trouble with a pivot table.

    As you can see from my attachment, the Count of Countries column totals fine. But the Count of More Countries column doesn't total correctly, it just seems to use the same totals as the Count of Countries column.

    The Count of More Countries column should read, or I want it to read:

    America 0
    France 3
    Ireland 1

    Can anyone see what I'm doing wrong here?

    Thanks!

    PS I'm using Office 2010
    Attached Images Attached Images
    Last edited by bystarlight; 07-29-2010 at 11:35 AM.

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