Pivot Table - show items with no data
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? |
That option isn't available if the source is an OLAP cube.
HJM wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Hi Debra,
I am creating the pivot table from an Excel spreadsheet. Do I need to set some other option? thanks, Helen "Debra Dalgleish" wrote: That option isn't available if the source is an OLAP cube. HJM wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
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. HJM wrote: Hi Debra, I am creating the pivot table from an Excel spreadsheet. Do I need to set some other option? thanks, Helen "Debra Dalgleish" wrote: That option isn't available if the source is an OLAP cube. HJM wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 08:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com