I have data where columns get populated dynamically and I need to sum the values from these dynamic columns. Example: dynamic column1dynamic coulm2dynamic coulmn3dynamic coulmn4Final sum12345234512345123455(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?

Calculate the value from dynamic columns

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?

Developer

@poornimak Here's a solution.

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

@poornimak Here's a solution.