In my spreadsheet I have a column called 'Severity'. This field defines an attribute of the other information in this same row. The potential entries in this column may be High, Medium or Low. When I first start entering data into the spreadsheet most likely all three entries will not be used. For example, I may have 10 rows of data but none of those rows will be classified as 'High' for severity.

In my pivot table I will group rows by "work week". For any given "work week" I want to pivot to have three columns, one for each level of severity and show me how many of each level of severity there is. If there are zero, such as with the example above. I want the pivot to show a column heading for 'High' but reported with a blank or a '0'.

How do I do this with a pivot table (i.e. have a fixed set of column headings even though there is no data to support the heading)?

Thank you in advance.

Figured it out. Check on the "Show items with no data" option in the field settings for columns. Easy. I need to create three "dummy" rows without dates to seed the column headings but it seems to work fine.