Dynamic Summarize Date field with Total

[BosKev]

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

[JosephSerpis · Accepted 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.

[BosKev]

Thank you!