Tom Johnson
New Member
- Joined
- Jul 3, 2014
- Messages
- 2
Hi all,
I've set up a pivot table which is working fine. However two of the fields I originally included are missing from the field list - but still appear in the 'values' area and in the table itself. If I drag them out of the values area, they disappear completely - rather than returning to the list above without a tick. One of these is a calculated field and the other is a heading coming from my data source.
Has anyone got any suggestions as to how I could stop this from happening?
Thanks,
Tom
I've set up a pivot table which is working fine. However two of the fields I originally included are missing from the field list - but still appear in the 'values' area and in the table itself. If I drag them out of the values area, they disappear completely - rather than returning to the list above without a tick. One of these is a calculated field and the other is a heading coming from my data source.
Has anyone got any suggestions as to how I could stop this from happening?
Thanks,
Tom