
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum a rangesum
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Brilliant! worked Like a charm thanks!
