Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Hi,
This might not be possible but I have a pivot table and there is a calculated field with various % based on the calculation.
What I am trying to figure out, can I add a slicer based on the calculated field in the pivot table? I don't seem to have an option, so I presume the slicer options are based on the raw data? (of which the calculated field would not be one, obviously I could add an extra column to the raw data as a calculated field per se but I wanted to avoid that.
Thanks
This might not be possible but I have a pivot table and there is a calculated field with various % based on the calculation.
What I am trying to figure out, can I add a slicer based on the calculated field in the pivot table? I don't seem to have an option, so I presume the slicer options are based on the raw data? (of which the calculated field would not be one, obviously I could add an extra column to the raw data as a calculated field per se but I wanted to avoid that.
Thanks