Hello everyone,
I have the below data,
And this is what I am aiming to achieve:
Basically, sum of revenue category and expense category separately for each month so that I can output visualizations.
Thank you!
@murthybhs
Version without macro.
Hi @murthybhs ,
A summarize tool should do the trick for you.
Please check the attached workflow.
Do let me know if this helped.
Best,
Jagdeesh
Thank you for the response Jagdeesh. What if there is a new month column added every month? Is there a way to automate it without manually changing the summarize tool?
