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 will also need to do the same for rows 7-11 to create row 12 but I guess the solution will be the same.
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.
View solution in original post
That's great sunny. It was easy enough to expand to work out 12 too.