Adding totals to dynamic table

[tiverson]

I have a monthly sheet that summarizes the daily activity of multiple accounts.  I want to add a totals column that will adjust and move to the end each time a day is added.  I will be using this workflow each month, so I can't just add it after x amount of days.  It needs to be flexible.

Thanks for any assistance

Desired Output

[atcodedog05 · Accepted solution]

Hi @tiverson 

Here is how you can do it.

Workflow:

Hope this helps : )

[RolandSchubert]

Hi @tiverson ,

transpose and cross tab could help you.

The Dynamic Select tool is useful to remove the existing Total column. Then add a RowId, use a Transpose tool to move column to rows, a Cross Tab tool to bring rows back to columns including the option to calculate e.g. row and column totals

Let me know if it works for you.

Best,

Roland

[atcodedog05]

Happy to help : ) @tiverson 

Cheers and have a nice day!