Sum a rangesum

[lewisjackson_eq]

Hi, would someone be able to explain how I would be able to do a sum on the following?:

Rangesum(Above(TOTAL Sum(column1)-sum(column2),0,rowno(TOTAL)))

I'm needing to put the sum of the above into a KPI field.

Would someone be able to help me out? Cheers

[swuehl · Accepted solution]

Sum( Aggr( Rangesum(Above(TOTAL Sum(column1)-sum(column2),0,rowno(TOTAL))), YourDimensionsComeHere))

Replace YourDimensionsComeHere with the dimensions you need to create the table you want to use Rangesum(Above(..)).

You might need to sort the aggr dimensions using the sort order you want.

The sortable Aggr function is finally here!

[lewisjackson_eq]

Brilliant! worked Like a charm thanks!