RangeSum PivotTable Issue

[RedStinger55]

Hi all, I am having trouble with rangesum in a pivot table in Qlik Sense.

I have an excel example of what I want Qlik to do.

I would like Qlik to take 1-the sum of the cumulative columns and rows that are left in the pivot table.

I have attached 2 images that should give you an idea of what the end result should look like in the table itself.

[sunny_talwar]

@RedStinger55 May be something like this

1 - RangeSum(After(Sum(Measure), 0, ColumnNo()))

[RedStinger55]

Yeah I couldnt get that to work as I tried something similar before.

I am thinking possibly its a combination of both after/below?