Pivot Table Won't Count Properly

**bystarlight** · 07-29-2010, 11:33 AM

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

**bystarlight** · 07-29-2010, 05:03 PM

Can anyone help? Please!

**pb71** · 07-29-2010, 05:40 PM

It would help (in future) to post an example workbook.

Anyway, to get the totals as above you would have to use something like the attached.

**bystarlight** · 07-30-2010, 05:49 AM

Thanks for your help!

**arthurbr** · 07-30-2010, 07:12 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save