Pivot Tables
 

I have a set of data in columns with an entry for a date in each row. I
would like to use a pivot table to calculate the totals in the rows by
month as oppose to by day. How do I roll up a dd/mm/yy format to
subtotal the months?

Regards

Filky


--
filky
------------------------------------------------------------------------
filky's Profile: http://www.excelforum.com/member.php...o&userid=11801
View this thread: http://www.excelforum.com/showthread...hreadid=492601

Pivot Tables
 

Right click on the date field in your pivot table. Select Group and Show
Detail and then Group. Click on Months (and maybe Tears) and then OK.

Hope this helps
Rowan

filky wrote:
I have a set of data in columns with an entry for a date in each row. I
would like to use a pivot table to calculate the totals in the rows by
month as oppose to by day. How do I roll up a dd/mm/yy format to
subtotal the months?

Regards

Filky

Pivot Tables
 

Of course that should read:
Click on Months (and maybe Years)...

Regards
Rowan

Rowan Drummond wrote:
Right click on the date field in your pivot table. Select Group and Show
Detail and then Group. Click on Months (and maybe Tears) and then OK.

Hope this helps
Rowan

filky wrote:

I have a set of data in columns with an entry for a date in each row. I
would like to use a pivot table to calculate the totals in the rows by
month as oppose to by day. How do I roll up a dd/mm/yy format to
subtotal the months?

Regards

Filky

Pivot Tables
 

Thanks Rowan - very obvious yet incredibly helpful when you don't
know..!


--
filky
------------------------------------------------------------------------
filky's Profile: http://www.excelforum.com/member.php...o&userid=11801
View this thread: http://www.excelforum.com/showthread...hreadid=492601

Pivot Tables
 

You're welcome.

filky wrote:
Thanks Rowan - very obvious yet incredibly helpful when you don't
know..!