I have an Excel 2000 pivot table, that displays column and row totals. I can use the getpivotdata function to get the row totals (i.e. getpivotdata (PVTable1,”March Johnson”). However when I use the same construct to get to the column total, the getpivotdata function returns “N/A” What am I doing wrong?
