Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

Straight Table - new row as sum of some others

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)

BREF.PNG

i.e.

6Total 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.

1 Solution

Accepted Solutions
sunny_talwar

Is this what you wanted?

Capture.PNG

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

2 Replies
sunny_talwar

Is this what you wanted?

Capture.PNG

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
Specialist
Specialist
Author

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