The enclosed file has data added on a weekly basis. I want to show the data in 3 ways and have tried to create 3 pivot tables to do this (see Pivot Table tab). However the MONTH figure appears as a date but I want it to appear as July, August, September as per the data. Also the DELAYS appear as a number of incidents rather than the actual delay number. What am I doing wrong ? I have manually created what I want the 3 pivot tables to show under the REPORT tab. Any help is appreciated. Kevin.
Bookmarks