jvantassel1
asked on
adding sumation of certain columns within pivot table
Attached is a sample worksheet with a calculated item showing the difference between TOA and critical funding levels for different years. I now want an aggregate of the TOA, Critical and difference for FY15 - 19 within the pivot table. I added columns R, S & T as an example, but it's not within the pivot table. Also attached is a PDF of a scanned page which was built strictly from "cut and paste". This is not my preferred way to build the data. I ultimately need to print a separate page for each MDEP. Also, if I add the SAG to the pivot I get the error "too many records". I haven't figured a way around this one yet either. I'm working in Excel 2007.
columnDifferenceSamplev1.xlsx
TOA-vs-Critical-Sample.pdf
columnDifferenceSamplev1.xlsx
TOA-vs-Critical-Sample.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER