When configuring a report, it would be great if information can be pivoted and not hardcoded. In other words on the report criteria the user would select two fields that needs to be compared against each other. When the report is extracted the two fields would be pivoted with expenditure to produce a report for example.
It is not always ideal to request the user to extract the information into excel to achieve this as these pivoted reports are mainly used by the executive team.
