Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated fields-Pivot tables | Excel Worksheet Functions | |||
Calculated items | Excel Discussion (Misc queries) | |||
PivotTable toolbar, Formulas, Calculated Item | Excel Discussion (Misc queries) | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
Excel 2002 -> Problem with calculated fields in Pivottable | Excel Discussion (Misc queries) |