Prev: Paste Formula
Next: How do I insert borders in every cell in a column
From: Warm FL on 18 Feb 2010 17:32
I am using Excell 2007, and I have create a pivot table, and I have a number
of reps that I want to display in my pivot and their sales amounts. In my
data table, I have created "dummy" rows with the reps names, but sales $ are
blank because they haven't sold anything. I want their name to show up in my
pivot table as blanks. Right now only names with sales show up.

I see under PivtoTable Options, under the Display tab ther is a box to click
to "Show Itmes with no Data on Rows", but it is greyed out.

Any idea how to un-grey out this option?
From: Debra Dalgleish on 19 Feb 2010 20:08
Those settings are for OLAP based pivot tables only.
If your pivot table is based on Excel data, right-click on a name in the
Sales Rep field
Click Field Settings
On the Layout & Print tab, add a check mark to Show Items With No Data
Click OK

Warm FL wrote:
> I am using Excell 2007, and I have create a pivot table, and I have a number
> of reps that I want to display in my pivot and their sales amounts. In my
> data table, I have created "dummy" rows with the reps names, but sales $ are
> blank because they haven't sold anything. I want their name to show up in my
> pivot table as blanks. Right now only names with sales show up.
>
> I see under PivtoTable Options, under the Display tab ther is a box to click
> to "Show Itmes with no Data on Rows", but it is greyed out.
>
> Any idea how to un-grey out this option?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

 | 
Pages: 1
Prev: Paste Formula
Next: How do I insert borders in every cell in a column