Show Average in Horizontal Pivot Table

[hansdevr]

Good morning specialists!

I need to do a horizontal (left to right) accumulation in a triangular pivot table.

Showing you starting table and desired result. Anyone suggestions how to go about this problem?

Start resultDesired table

[marcus_sommer · Accepted solution]

Try it with something like this:

rangesum(before(sum(YourValue), 0, columnno()))

- Marcus

[hansdevr]

Brilliant, Marcus!! Thank you very much!!