LSlisher11
New Member
- Joined
- Sep 23, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello,
I have a report that has slicers that filter by the count of an identifier in a pivot table.
However, when choosing the options for the slicer, the values aren't filtered properly.
I tried to recreate the slicer and when I went to the ribbon -> PivotTable Analyze -> Insert Slicer, the raw data column headings for the pivot table are shown as options instead of the pivot table fields.
So the field of the pivot table that I want to filter does not populate in the slicer options window.
This slicer is macro generated along with other slicers that all seem to work correctly.
I have a report that has slicers that filter by the count of an identifier in a pivot table.
However, when choosing the options for the slicer, the values aren't filtered properly.
I tried to recreate the slicer and when I went to the ribbon -> PivotTable Analyze -> Insert Slicer, the raw data column headings for the pivot table are shown as options instead of the pivot table fields.
So the field of the pivot table that I want to filter does not populate in the slicer options window.
This slicer is macro generated along with other slicers that all seem to work correctly.