I have a pivot Table showing all the values. I would like to know how to display only the positive values on the pivot table
It would be appreciated if someone on this Forum could kindly help me in resolving this issue
I have a pivot Table showing all the values. I would like to know how to display only the positive values on the pivot table
It would be appreciated if someone on this Forum could kindly help me in resolving this issue
Right click on pivottable's row label field. Make sure to pick the level where you want the filter to be applied to.
Filter->Value Filter
Value Field is greater than 0.
If there is more than one field you'd need to apply filter to. I'd recommend transforming/filtering data in PowerQuery/Get & Transform.
Then load to data model and base your pivot table off of it.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks