If there are calculated items in the pivot table, the subtotals can only
be the Automatic function. They can't be changed to a different function.
Lackawanna52 wrote:
I have a pivot table, with a calculated item. When i try and subtotal on the
field which includes the calculated item i receive the following error
"Unable to set the Subtotals property of the PivotField class". If i don't
create the calculated item if works fine. What have i missed?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html