This is probably a really easy thing to do that I am just overlooking. I have a pivot table that I am showing just the bottom 10 customers (row field) by sales (data field), however only want to include those accounts with sales not equal to 0. How do I do this within the pivot table?
Thank you in advance for your assistance,
N
Bookmarks