Forum menu
Topic starter
Have two rows, the first one has dates in it. the second one numbers.
the dates are by day as in 13th March 2009.
I am trying to get a pivot table to give me a total of the numbers for each calendar month.
can any one help please!!!!!!
PS not sure the pivot table is the right way of doing it.
thank you
Dave
Posted : 21/12/2009 10:31 am
Topic starter
or is it a 'sum' and 'if' thing?
Posted : 21/12/2009 10:55 am
Copy the date column/row, paste it next to your other data, format the 2nd data date row/column to show just months eg Mar-09 then run the pivot table wizard on it
Posted : 21/12/2009 10:57 am
Use the month and year functions eg [i]=concatenate(year(A1),month(A1))[/i] (assuming date in field A1) which should give you YYYYMM formate which you can then do a pivot on
Posted : 21/12/2009 10:58 am
Topic starter
Thank you very much you two. has worked.
Dave
Posted : 21/12/2009 11:21 am