Hi,
I am really having problems with one of my pivot tables.
I have a sheet with a lot of data on it for work related tasks. One of the columns is defined as an Ageband, which is shown as 1. 0 to 5 days, 2. 6 to 10 days etc going up to 7. 61+days
When I come to do a pivot table of Task (Row) against Ageband (Column), with the count of Ageband in the data area I get problems.
If all the Ageband's are used then it's fine, but if some of the Agebands are not used the Pivot misses that column completely, which causes a problem as I need the columns in the pivot i.e. the Agebands to be fixed and to appear even if there are no counts for them.
Anybody got any ideas how to do this ?????
Many Thanks
ITWhiz
Bookmarks