Forum Discussion
Return Data from Privot table according to sums.
Hi
When you refer to a cell from a Pivot Table into another cell, Excel creates a GETPIVOTDATA function.
This function creates an ABSOLUTE reference. You can either:
- Put the GetPivotData function in the edit mode F2 >> then edit the hardcoded reference, OR
- Turn Off this functionality by clicking on File >> Options >> Formulas >> take the Check away from "Use GetPivotData Function for Pivot Table References" >>OK
Hope that helps
Nabil Mourad
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.
