Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot tables show zeros | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |