I have a bunch of groups that I need to separate into separate tabs and everything works great except I can't figure out how to add totals for certain fields to each tab. I've attached an example. In reality, there are significantly more than just 4 groups and the specific groups change from time to time (the format of the input data is always the same, but the groups within change from period to period).
Is there a way to accomplish this? Thanks in advance!
Solved! Go to Solution.
@MarkD - Please check the attached workflow , I created the totals using summarize tool and further added a union tool to combine it with the main dataset.