Forum Discussion
shotgun-68
Jul 08, 2021Copper Contributor
Getting a Pivot to ignore zero values in Top 10 filter
I have a number of pivots that make up a sales report. Within that I have top and bottom 10 filters to focus on the main challenges/opportunities However, using Top 10 if the sales person (a...
Marcia1720
Jul 08, 2021Copper Contributor
Open the File Tab>Options>Advanced>scroll down the window until Display Sheet>Uncheck Remove zero with zero values>Ok
I do not have my laptop with me so I'm just sharing this from memory.
I do not have my laptop with me so I'm just sharing this from memory.