Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table and would like to include a calculated measure as a running total, e.g., row 1 has 50, row 2 has 25, and row 3 has 20. The running total would show 50 in row 1, (50 + 25 = 75) as the final value in row 2, and (50 + 25 + 20 = 95) as the final value in row 3. Is this possible in a pivot table, and if not, is there another way to do this but still retain the functionality of a pivot table, i.e., fields in rows + columns?
It should be possible. Would be able to share sample data and snapshot of required pivot table