Forum Discussion
Return Data from Privot table according to sums.
Hello Wizards, I need to get data form a pivot table according to the sum values in the table. I have a table that has each store's name, address, zip, etc on the vertical left of the table with the ...
Your description says "show me every store that has not sold last month".
Your formula says "show me every store that has sold last month".
So, what should be?
I need lists of both. one so that we know what stores are carrying what products still and one that says what stores have stopped selling.