Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Copper Contributor

Jul 25, 2023

Slicer Tool

I have a pivot table with a the same source data displayed in a column as an average and again as a sum. Is is possible to apply a slicer to each?

SergeiBaklan
MVP
Jul 25, 2023
KRandall1996

What do you mean "to each"? Slicer is applied to the field, not to aggregate value.
- KRandall1996
  Copper Contributor
  Jul 25, 2023
  I was hoping there was a way to apply a slicer to Sum of V and Average of V

Share

Resources