Pivot Tables

[filky]

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

[Rowan Drummond]

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
>
>

[Rowan Drummond]

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
>>
>>

[filky]

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

[Rowan Drummond]

You're welcome.

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