ExcelBanter - Pivot table items

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table items (https://www.excelbanter.com/excel-discussion-misc-queries/58763-pivot-table-items.html)

suepro

Pivot table items

How can I create new items in pivot tables with Office Professional 2003?
The formula option that used to be in the menu has been deleted. Thanks.

Roger Govier

Pivot table items

Hi

It is still there.
highlight a field within your PT.
From the PT toolbar, use the dropdown Pivot Table, 9th item down Formulas,
from that sub-list, second entry, Calculated Item.

Regards

Roger Govier

suepro wrote:
How can I create new items in pivot tables with Office Professional 2003?
The formula option that used to be in the menu has been deleted. Thanks.

All times are GMT +1. The time now is 06:06 AM.