You can find a report with an example and explanation here: https://flex.bi/bi/accounts/47/cubes/HansaWorld%20Invoices/reports/1882-alternative-for-total-function-not-working-correctly