Total Column

[steve_matthews]

Hello,

Hopefully a pretty straight forward question here.  I'm new to Alteryx and have just started building my first basic workflow. However I am stuck with this problem. I want a total column (on the far right side of the data) which adds up all the months values per customer. The months/customers will change each time I run the report. 

Thanks in advance.

Steve 

[Luke_C]

Hi @steve_matthews 

Try checking 'Total Column' in your cross tab tool. That should dynamically update with your changing columns.

[PanPP · Accepted solution]

Hi @steve_matthews 

If you right-click the cross tab tool at the top of Designer, you can open up an example. 

One of the examples (last example), if you configure the cross tab tool shown below. you will get a total column / total row value.

Hope this helps. If it does, please like the post and mark it as a solution.

[steve_matthews]

Thanks Luke, just what I was looking for!

Regards

Steve

[steve_matthews]

Perfect - thanks for your help!

Regards

Steve