TopSum
The TopSum function returns, in order of decreasing rank, the topmost rows of a table whose cumulative total is at least a specified value.
Syntax
TopSum(<table expression>, <rank expression>, <sum>)
Applies to
An expression that returns a table, such as a <table column reference> or a function that returns a table.
Return Type
<table expression>
Remarks
The TopSum function returns the topmost rows in decreasing order of rank based on the evaluated value of the <rank expression> argument for each row, such that the sum of the <rank expression> values is at least the given total specified by the <sum> argument. TopSum returns the smallest number of elements possible while still meeting the specified sum value.
For example, assume that a table column named [Products] contains this table:
| Product Name | Unit Sales |
|---|---|
| Apples | 1200 |
| Kiwi | 500 |
| Oranges | 1500 |
| Lemons | 750 |
TopSum([Products], [Unit Sales], 2500) returns the following table:
| Product Name | Unit Sales |
|---|---|
| Oranges | 1500 |
| Apples | 1200 |