Hello,
First post here -- In the screenshot below, the data in cells B5:C8 does not match the pivot filter selected in cell B5. The total for row 6 should only be $704.06 but data displayed is for another project. i can double-click the value in cell B6 and the new sheet that opens show a different "Funded Program". I tried removing/re-adding/re-filtering pivot filter but nothing changes. I validated data source and that's okay. I did create a new pivot table from the same data and everything works as it should. I would prefer not recreating 20+ pivot table as there are several formulas linked to existing pivot tables. Any suggestions for a fix?
First post here -- In the screenshot below, the data in cells B5:C8 does not match the pivot filter selected in cell B5. The total for row 6 should only be $704.06 but data displayed is for another project. i can double-click the value in cell B6 and the new sheet that opens show a different "Funded Program". I tried removing/re-adding/re-filtering pivot filter but nothing changes. I validated data source and that's okay. I did create a new pivot table from the same data and everything works as it should. I would prefer not recreating 20+ pivot table as there are several formulas linked to existing pivot tables. Any suggestions for a fix?