Hi, I've got a list of items all with associated dates - I want to create a
pivot table that will count the number of items for each calendar month - how
can I change the display on the pivot to reflect the month?
Dave
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/10/2010 2:09:03 PM |
|
Right-click on a date, and choose Group...
In this dialogue box, you can choose to group by months.
If you get the error "Cannot group that selection", it means that some of
your data are not dates. You'll need to fix that first.
Regards,
Fred
"Dave Eade" <DaveEade@discussions.microsoft.com> wrote in message
news:26FE98BA-060A-4B9E-8CC5-2E42678996BC@microsoft.com...
> Hi, I've got a list of items all with associated dates - I want to create
> a
> pivot table that will count the number of items for each calendar month -
> how
> can I change the display on the pivot to reflect the month?
>
> Dave
>
|
|
|
0
|
|
|
|
Reply
|
Fred
|
3/10/2010 2:25:07 PM
|
|
Fred, Thanks for that....
.....However am I right in thinking that a date in January 2009 will be
"grouped" with a date in January 2010 etc??
"Fred Smith" wrote:
> Right-click on a date, and choose Group...
> In this dialogue box, you can choose to group by months.
>
> If you get the error "Cannot group that selection", it means that some of
> your data are not dates. You'll need to fix that first.
>
> Regards,
> Fred
>
> "Dave Eade" <DaveEade@discussions.microsoft.com> wrote in message
> news:26FE98BA-060A-4B9E-8CC5-2E42678996BC@microsoft.com...
> > Hi, I've got a list of items all with associated dates - I want to create
> > a
> > pivot table that will count the number of items for each calendar month -
> > how
> > can I change the display on the pivot to reflect the month?
> >
> > Dave
> >
>
> .
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
3/10/2010 4:40:01 PM
|
|
Hi Dave
Yes it will, if that is what you want.
However, if you select both Year AND Month for the Grouping, then your
years will be shown separately, and the Months within each Year.
You could, if you wanted drag Year to the Page Field (or Filter) area
and then select only a given year for example.
--
Regards
Roger Govier
Dave Eade wrote:
> Fred, Thanks for that....
> ....However am I right in thinking that a date in January 2009 will be
> "grouped" with a date in January 2010 etc??
>
> "Fred Smith" wrote:
>
>> Right-click on a date, and choose Group...
>> In this dialogue box, you can choose to group by months.
>>
>> If you get the error "Cannot group that selection", it means that some of
>> your data are not dates. You'll need to fix that first.
>>
>> Regards,
>> Fred
>>
>> "Dave Eade" <DaveEade@discussions.microsoft.com> wrote in message
>> news:26FE98BA-060A-4B9E-8CC5-2E42678996BC@microsoft.com...
>>> Hi, I've got a list of items all with associated dates - I want to create
>>> a
>>> pivot table that will count the number of items for each calendar month -
>>> how
>>> can I change the display on the pivot to reflect the month?
>>>
>>> Dave
>>>
>> .
>>
|
|
|
0
|
|
|
|
Reply
|
Roger
|
3/10/2010 4:52:01 PM
|
|
|
3 Replies
413 Views
(page loaded in 0.058 seconds)
Similiar Articles: Show Pivot Table Dates in a Month/Year Linear Fashion - microsoft ...Hello, Is there a way to show dates in an Excel 2007 Pivot table in a Month/Year Linear fashion? Any help/suggestions will be greatly apprec... Pivot table show all days of a month even if no data - microsoft ...start off the pivot table data with blank records of all the dates in the range you want. -- Hope this helps. If it does, please click the Yes button. Pivot Table Month Order - microsoft.public.excel.miscPIVOT TABLE - Show Dates in months - microsoft.public.excel ... The Order Date column of ... Grouping Pivot Table Dates ... ... Pivot Table Month Order - microsoft.public ... Getting my chart to display dates - microsoft.public.excel.misc ...Excell 2007, and I have create a pivot table, and I have a number of reps that I want to display in my ... PIVOT TABLE - Show Dates in months - microsoft.public.excel Pivot Table Change to US Date Format - Why? - microsoft.public ...Pivot Table Month Order - microsoft.public.excel.misc Pivot Table Change to US Date ... Excel 2007 -- Dates in Pivot Tables in wrong order after refresh ..... excel.misc What ... Pivot table define Monday as first day of week - microsoft.public ...Count Wednesdays within a calendar month - microsoft.public.excel ... For the first week of ... How do I find how many of a ... PIVOT TABLE - Show Dates in months ... Excel 2007 -- Dates in Pivot Tables in wrong order after refresh ...PIVOT TABLE - Show Dates in months - microsoft.public.excel ... Excel 2007 -- Dates in Pivot Tables in wrong order after refresh ... Pivot Table Month Order - microsoft ... Change quarters in Pivot table when grouping - microsoft.public ...Grouping Dates in Pivot Tables - Show Pivot Reports by Month ... Learn how to use Microsoft Excel Pivot Tables to group report data by weeks, months, quarters or ... Month in report header based on dates in data table - microsoft ...Grouping Dates in Pivot Tables - Show Pivot Reports by Month ... Do you know you can group dates in pivot tables to show the report by week, month ... Grouping dates in pivot table - microsoft.public.excel.misc ...Pivot table show all days of a month even if no data - microsoft ... start off the pivot table data with blank records of all the dates in the range you want. Grouping Dates in Pivot Tables - Show Pivot Reports by Month ...Do you know you can group dates in pivot tables to show the report by week, month or quarter? I have learned this trick while doing analysis on a pivot table today. PIVOT TABLE - Show Dates in months Excel - Excel Discussion List ...Hi, I have got a list of items all with associated dates - I want to create a pivot table that will count the number of items for each calendar month - ho Pivot Table | Grouping | Group Dates by LevelsWhen creating an Excel pivot table from data with a date field, you can use the Group function to convert the dates to months ... as a field but will now show up ... PIVOT TABLE - Show Dates in months - Lockergnome ForumsPosted: Wed Mar 10, 2010 6:09 am Post subject: PIVOT TABLE - Show Dates in months Archived from groups: microsoft>public>excel ... Grouping Pivot Table Dates by Months and Weeks - Excel Pivot TablesIn a pivot table, there's no built-in way to group the pivot table data by both weeks and months at the same time. If you want to show sales data by week, you 7/22/2012 12:59:58 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
7 followers. 