Thread
:
Pivot Tables: How do I show ALL field rows, including empty rows??
View Single Post
#
2
Debra Dalgleish
Posts: n/a
Double-click the Name field button
Check the box 'Show items with no data'
Click OK
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!
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Reply With Quote