Sub Totals as a calculated field in a pivot table

  • Thread starter Thread starter Chesil
  • Start date Start date
C

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

Chesil said:
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
Click to expand...

__________ 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
 
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.
 
Back
Top