Calculate the value from dynamic columns

[poornimak]

I have data where columns get populated dynamically and I need to sum the values from these dynamic columns.

Example:

dynamic column1	dynamic coulm2	dynamic coulmn3	dynamic coulmn4	Final sum
12345	2345	12345	123455	(dynamic column1+dymanic column2+dymanic column3+dymanic column4+…)

dynamic columns are my inputs and Final sum is my expected output.

My input columns may increase or decrease. How do I achieve my Final sum Field?

[alexnajm]

I would Transpose the columns, then Crosstab them back with the Sum AND Total Column options selected!

[Prometheus · Accepted solution]

@poornimak Here's a solution.