Dueling Excel 89

PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function?


See Mr Excel and excelisfun use two methods to shows PivotTable Grand Totals to the left of the PivotTable (Since there is no way to do it within the PivotTable, see two formulas that can do it using LOOKUP and GETPIVOTDATA functions. Also see the IF and ISBLANK functions.


Be the first to comment

Leave a Reply