Calculate TOTAL of a column

[GabrielOtet]

Hi,

Is it possible to calculate the percentage of the cell relative to the entire column?

Something like count(Field)/count(SUM Field for entire column).

I have tried many options (especially with TOTAL and filters) but none of them gave me the right answer.

The table is looking something like this:

[GabrielOtet · Accepted solution]

In the meantime, I have found the solution, in case anyone wants to use it:

Count(field)
/
(RangeSum(Below(count(field),0,(NoOfRows()-RowNo()+1)))+RangeSum (above(count(field),1,(RowNo()-1))))

Basically there is the sum of all the values above and all the values below including the current one.