Display No Data in Pivot

W

Warm FL

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?
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table as a data collection tool 3
display all row fields in pivot table 1
Pivot table data need to show zero even no data under column 1
Slicers and Calculated Items in Pivot Table 2
Add Sales Goals to Sales Report in Pivot Table 1
Value filter missing in pivot table 3
always display rows in Pivot tables (show items with no data) 1
Show Pivot Table Items That Have No Data 0

Top