Hi! I'm wondering if there is a way to sum within a pivot table. For example, I have this table:

PivotSum.PNG

And I'm trying to find a way to show a Status as "End" and the summation of Sub-Element 1 within the same pivot table without adding the summation to the total. So it would show the total of Sub-Element 1 as 2,500, 2,000, and 1,500. I know if I just pull out the "Status" then it would sum correctly, but I'd like to see the before and after changes.

Any ideas?