Running sum - Backwards!!????

[rich_bell20]

Hello everybody, I have searched the forums and noone seems to have asked this questyion and i would like to know if it is possible.

I have a report which shows VAT charged, and it is ordered by the orderdate, which i have DESCENDING. so it shows the last order type in, at the top of the table. If i have a running sum on the vat amount though, it does it going down the page. anyone know if it's possible to have one running up the page, so the total is always at the top, thanks everyone!!

Richard

 

[Cosmos75]

Add a textbox for your detail section and name it txtGrandTotal [=SUM(VAT)]. Your running some textbox named txtRunningSum [Datasource = VAT, Running Sum Property = Yes (over Group)].

Use formula Grand Total - Running Sum + Detail in textbos in detail section

txtGrandTotal - txtRunningTotal + txtVAT

VAT, Running Sum, Grand Total - Running Sum + Detail
5 5 180
10 15 175
15 30 165
20 50 150
30 80 130
50 130 100
40 170 50
10 180 10

Is that what you were looking for?