Hello,
Not sure if this is possible, but I figured I'd ask.
I have a Pivot Table that is broken out by the 5 different USSGL GROUPs listed in the below screenshot. I want to add a new Calculated Field that only shows the Sum of the Amount for the Cumulative of Commitments (aka. COMMITMENTS (CUM)), which would be 47xx Commitments + 48xx UDO + 49x1 Unpaid Expenditures + 49x2 Paid Expenditures (so only leaving 4610 Allotment out). Is it possible to use a SUMIF to create a new Calculated Field?
Also I want to note that I was able to do a Calculated Item in the USSGL GROUP to show the COMMITMENTS (CUM), but it only allows the Calculated Item to show up under the USSGL GROUP Row. I was hoping to add an entirely new Row (I assume using Calculated Field) to show the COMMITMENTS (CUM).
Ultimately I'm trying to get the Pivot Table to automatically spit out a table that looks more like the bottom screenshot. Thank you for your help.
Not sure if this is possible, but I figured I'd ask.
I have a Pivot Table that is broken out by the 5 different USSGL GROUPs listed in the below screenshot. I want to add a new Calculated Field that only shows the Sum of the Amount for the Cumulative of Commitments (aka. COMMITMENTS (CUM)), which would be 47xx Commitments + 48xx UDO + 49x1 Unpaid Expenditures + 49x2 Paid Expenditures (so only leaving 4610 Allotment out). Is it possible to use a SUMIF to create a new Calculated Field?
Also I want to note that I was able to do a Calculated Item in the USSGL GROUP to show the COMMITMENTS (CUM), but it only allows the Calculated Item to show up under the USSGL GROUP Row. I was hoping to add an entirely new Row (I assume using Calculated Field) to show the COMMITMENTS (CUM).
Ultimately I'm trying to get the Pivot Table to automatically spit out a table that looks more like the bottom screenshot. Thank you for your help.
Last edited:
