Forum Discussion
Return Data from Privot table according to sums.
Thank you so much for the suggestion, but I think the issue is more than i need to create a list of all the stores with sales through specific months and a list of of all the stores without sales for those specific months.
I understand how to edit the GETPIVOTDATA formula just fine but I'm not sure how to create a formula in a way that it will give all the store names without sales in a specific month. I would just reference the source data but there are only records of sales. rather than record for every month.
Does that make sense?
I've tried slicers but and filters but, again you can't sort by data that doesn't exist or is blank.
would you please attach a sample Excel file?
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.
