Hi Hung,

Yes, you can. 

Create a Structure with TypeName and Total attributes.

Create an Aggregate and use a group by on Type:

• right click on the column
• choose Group by <column name> (in this case, Ty´pe)
• right click on the Total column
• choose Sum.

This Aggregate will return the Sum of Total column to each Type.

Iterate over the result and put it in a list of the structure you have created. While iterating, gather the total values in order to have the total for all types. When its over, add another structure on the list, but, now, with TypeName "Total" and the sum of the Totals.

Put the list inside a List Records.

Hope this could help.

Best Regards.

Hi Hung,

You can refer to this video for auto calculate when user input data on Data Grid:

https://www.youtube.com/watch?v=pX5zX3tRMOI

>>then display them to "Summary" panel? 

Use global variable to save total and set it into Expression

Hello Hung,

Your last question should be on another topic, but I would that you can't.

The dropdown's options needs to have a Id and Label, if you have no Id yet you should first register the new option.

Kind regards

Ricardo