If you are applying a number of different result manipulations, the order they are calculated is important. Results are always computed based on the first result manipulation listed.
For example, if you want to look at the rolling total of the top results in your data, you would first want to calculate the top results and then the rolling total. This would mean your top/bottom filter would be listed before your result path calculation.
To order result manipulations
- In the report builder, click the result manipulation icon ().
- Select the Order of result manipulation option.
- Drag and drop the manipulations to your preferred order.
- Click Apply.
- Your order is added to the Filters panel.