Hi all,

How can you add a row to a pivot table which is calculation the total amount of numbers per column devided by the total of numbers of the complete pivot table. I tried to use sum but when I select a different filter expression in the pivot, the sum is overwritten or you can find down below in your screen. I would like to see this sum 2 record below the pivot table, regardless how large the pivot can gow or shrink.

rgrds,

Paul.