Zohra has attended:
Excel Advanced course
Excel Intermediate course
Excel VBA Intro Intermediate course
Grouping data in a pivot table
Hi,
I have some data in cluding a field of dates, which is in the form of 'dd/mm/yyyy 00:00'.
Its an extracted report so the data looks like this:
27/06/07 12.42
28/06/07 19.42
etc, etc
I'm trying to use a pivot table to display the data, and need the dates grouped by month.
Any ideas on how to group the data without having to manually check each date (I'd like to automate this so that it can produce this graph on a daily basis).
RE: Grouping data in a pivot table
Hi Zohra. I'd think about filtering your source data before creating the pivot table. Remember you can apply a custom filter to the date to pick out a specific range. You can then use just those records to generate the pivot table. Alternatively, create a new "Month" column with just Jan, Feb, Mar values in it and as long as you kept the source data up to date you could use that column as the page field to generate your pivot tables.
Hope this helps,
Anthony
