Pivot Table - show items with no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a pivot table and only want to show items with data. When I
leave the "show items with no data" unchecked, it still shows all data. The
help pages indicate that some types of source data does support this option.
Which types would they be?
 
Hi Debra,
I am creating the pivot table from an Excel spreadsheet. Do I need to set
some other option?

thanks,
Helen
 
If your pivot table includes a calculated item, it may show all the
items for some fields, even if "Show items with no data" is unchecked.
 
You must log in or register to reply here.

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

always display rows in Pivot tables (show items with no data) 1
pivot table calc item 8
Problem with Calculated item in Pivot Table 1
pivot table data 2
pivot table excel 2007 -- show rows with no data 1
Display No Data in Pivot 1
Pivot table - calculated item 0
Data Lookup Question 1

Back
Top