So I am trying to understand the GETPIVOTREPORT formula in excel. I am trying to run some formulas (Rank, IndexMatch, Sumifs...ect) off of a pivot report and wanted to know what the best way to do so without having to redo formulas once I change the filter in the report. Is this something a GETPIVOTREPORT would help with or are there other ways? Thanks!