Hi everyone,
Please help with calculated fields. I have a pivot table in which I have selected calculated fields. The insert calculated field dialog pops up. However, when I type a name and a formula, I get the following message:
"An item cannot be found. Check that you've typed the name correctly and the item is present in the Pivot Table report."
Of course the item isn't present--I am trying to add the field!
Yuck--please help.
Thank you,
Please help with calculated fields. I have a pivot table in which I have selected calculated fields. The insert calculated field dialog pops up. However, when I type a name and a formula, I get the following message:
"An item cannot be found. Check that you've typed the name correctly and the item is present in the Pivot Table report."
Of course the item isn't present--I am trying to add the field!
Yuck--please help.
Thank you,