Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi All,
I want to be able to summary the column total when there are new month coming up. Any solutions? Thanks.
Right now I'm using a summarize tool
| DIVISION NAME | 2019_01_31 | 2019_02_28 | 2019_03_31 | 2019_04_30 | Total |
| A | 0 | 1 | 0 | 0 | 1 |
| B | 0 | 1 | 2 | 0 | 3 |
| C | 15 | 21 | 27 | 14 | 77 |
| D | 14 | 19 | 22 | 28 | 83 |
| Total | 29 | 42 | 51 | 42 | 164 |
Solved! Go to Solution.
Hi @BosKev if you transpose your data then use a crosstab you can add in a Total Row and Total Column field within the method for aggregating values. I attached the workflow as well.
