View Single Post
  #1   Report Post  
 
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!