Add aggregation line to existing Table Box

[#1]

Hi

I have an existing Table Box with some Revenue field. I would like to add one row with the total revenue over all rows in the table.

Is it possible and how ?

tks

[Gysbert_Wassenaar]

An example doesn't necessarily mean your original document. See this document: Preparing examples for Upload - Reduction and Data Scrambling

You can use the expression editor to create the expression. On the Expression tab click on the ... (three dots) after the input field for the expression to open the Expression Editor. Then select the aggregation function from the dropdown list. Next choose the field from the Fields dropdow box. Finally click on Paste to create the expression. Click on OK to close the expression editor.

[#3]

this is giving me the error message i enclosed.

so, i tried to manually enter the expressions you suggest: Sum(Revenue) ...

I am getting a (strange) table with: in the portfolio column, nothing, a column with revenues, and a column with sum of revenues... whereas i would like to have an additional row, in the end of the table, with the sum of the revenues over all the portfolios...

is it possible?