A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Pivot Tables: How do I show ALL field rows, including empty rows??



 
 
Thread Tools Display Modes
  #1  
Old April 8th 05, 05:25 PM
[email protected]
external usenet poster
 
Posts: n/a
Default Pivot Tables: How do I show ALL field rows, including empty rows??

In creating a pivot table, is there a way to "show all" even if there
isn't any data?

example:

Name value
category1 $40
category2 $60
category3 0

Usually, category3 would be filtered out by the pivot table because it
is empty. I need the category to be displayed regardless of whether it
has values in it. Can this be done??

thanks!

Ads
  #3  
Old April 8th 05, 06:21 PM
Gary Brown
external usenet poster
 
Posts: n/a
Default

Sounds like category 3 isn't even in the data that the pivot table is created
from. At the end of the data, stick a listing of the categories. Now they
will show up.
HTH,
Gary Brown


" wrote:

> In creating a pivot table, is there a way to "show all" even if there
> isn't any data?
>
> example:
>
> Name value
> category1 $40
> category2 $60
> category3 0
>
> Usually, category3 would be filtered out by the pivot table because it
> is empty. I need the category to be displayed regardless of whether it
> has values in it. Can this be done??
>
> thanks!
>
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot tables show zeros sueanne Excel Discussion (Misc queries) 5 June 8th 09 07:32 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM
pivot table - hide details but show subtotal for calculated field tenneym Excel Discussion (Misc queries) 1 February 9th 05 03:07 AM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 12:22 AM


All times are GMT +1. The time now is 06:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.