Pivot Table Issue

		Microsoft Office Forums > Microsoft Excel > Excel
Pivot Table Issue

FAQ

Thread Tools

Display Modes

10-28-2012, 09:08 PM

Grovesy

Windows 7 64bit Pivot Table Issue

Office 2010 64bit

Novice

Join Date: Oct 2012

Posts: 1

Pivot Table Issue

Hi,
Hope you can help with a Pivot Table issue.
In my data fields there are blanks and Yes's.
I only want to show a 1 in the PT where there is a Yes in the data but it's showing a 1 for both Blanks and Yes's.

What do I need to configure to change this?
Tks, Alan

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table	uhlersa	Excel	0	10-15-2012 12:01 PM
Pivot table help	TishyMouse	Excel	2	04-27-2012 10:19 AM
pivot table	aliasadi_07	Excel	1	03-11-2012 12:49 AM
Help with a pivot table please!	natsha	Excel	1	02-16-2012 12:41 PM
Pivot Table	Karen615	Excel	5	08-03-2011 10:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:30 PM.