How to make a report comparing two amount fields

[Suhani-gupta003]

Please tell me how to create report which shows comparison of two field named amount being sought and amount approved such that it displays only those records created last week i.e first it takes sum of both the fields and then separately displays the amount for the last week as one amount each. The table is sn_customerservice_application

[Uncle Rob]

You can't create dynamic columns in the report.  You need a separate field to store the sum if you want it to show up on a report with the values of its components.