Can anyone explain to me why the pivot table in the attachment does not use the dates in row A as labels please? I have spent hours trying to work this out but am completely stumped!
Thanks in advance!!!
PS I'm using Excel 2010.
Can anyone explain to me why the pivot table in the attachment does not use the dates in row A as labels please? I have spent hours trying to work this out but am completely stumped!
Thanks in advance!!!
PS I'm using Excel 2010.
Last edited by tuph; 02-03-2014 at 07:56 PM. Reason: add Excel version
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Hi tuph,
Your data isn't formatted correctly for a Pivot.
You need to convert this to 2 Columns - 1 for the Dates & another for the Figures.
I've attached an example.
Cheers
Remember you are unique, like everyone else
Thanks for your suggestion Boffin but this is a shared workbook and the data needs to be formatted with dates as column headings. A sample of my full worksheet is attached. How can I summarise this by month?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks