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?
Solved! Go to Solution.
I would Transpose the columns, then Crosstab them back with the Sum AND Total Column options selected!
@poornimak Here's a solution.