Straight Table - new row as sum of some others

[shane_spencer]

I've got this chart/table (see below). It's very simple expression to get Final value is: sum(AMT_NET_TAXREP_clo_1*VATFORM_POLARITY)

What I need to do is create a new row where the Ref: is 6 that is the sum of row (Ref) 1, 2, (3 if it exists), 4 and 5. Is that possible?

n.b. I'd also like to give it the Description: Total sales (amount SAR)

i.e.

6

Total sales (amount SAR)

20,543,502.70

I will also need to do the same for rows 7-11 to create row 12 but I guess the solution will be the same.

[sunny_talwar · Accepted solution]

Is this what you wanted?

Added a new table in the script by doing a binary load... also had to remove your hidden script to be able to run the binary load.

[shane_spencer]

That's great sunny. It was easy enough to expand to work out 12 too.