PivotTable - calculated items?
 

When I am creating a calcuated item, the dialog box has an Insert Field
button. THis seems wrong - my understanding is that a calculated item is
based on items in a field, not on a field itself. So, you would never insert
a field name in a calculated item formula. Is this button an error or am I
missing something?

--
Peter Aitken

Remove the crap from my email address before using.

You can use Insert Field button to add a field name, and use it as a
positional reference. For example, for the Region field:

=Region[2]*.5

Peter Aitken wrote:
When I am creating a calcuated item, the dialog box has an Insert Field
button. THis seems wrong - my understanding is that a calculated item is
based on items in a field, not on a field itself. So, you would never insert
a field name in a calculated item formula. Is this button an error or am I
missing something?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html