Sub Totals as a calculated field in a pivot table

[Chesil]

I have a pivot table that pulls revenues product line and displays in
monthly columns.

Can I create a subtotal that displays quarterly data as a calculated field?

In another pivot table I have revenues and costs associated with a variety
of projects. Is there a way to subtotal the costs separately from revenues?

Thanks for reading.

 

[Roger Govier]

Hi Chesil

take a look at the Group functionality within Pivot Tables.
You can achieve all that you want with that, without having to resort to
calculated fields.
Just highlight the items you wish to Aggregate>Right click>Group and give a
name to the grouping.

--
-------
Regards
Roger Govier

I have a pivot table that pulls revenues product line and displays in
monthly columns.

Can I create a subtotal that displays quarterly data as a calculated
field?

In another pivot table I have revenues and costs associated with a variety
of projects. Is there a way to subtotal the costs separately from
revenues?

Thanks for reading.

__________ Information from ESET Smart Security, version of virus
signature database 4897 (20100226) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4897 (20100226) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4901 (20100227) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Chesil]

Managed to answer my own question using a calculated item rather than
calculated field.

I'll be happy to see the 255 character limitation removed in the next
version as that created a degree of hassle to workaround.