#1
|
|||
|
|||
fixed columns in a pivot table
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. |
#2
|
|||
|
|||
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.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Fixed Stationary Columns (Word 2010) | ptristan88 | Word | 5 | 07-02-2014 07:28 PM |
Can you add percentage (%) columns to a pivot table? | New Daddy | Excel | 2 | 11-23-2013 09:49 PM |
Fixed duration, fixed units, fixed work, effort driven. How, why and when use it all | Evgeny | Project | 3 | 01-03-2013 06:45 AM |