Adding Sub-Total Row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can I dinamically add Sub-Total Rows and get the SUM of each column?
This is what I have:
This is what I need:
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What you want to do is branch off a path in the flow with a Summarize Tool that groups your data by the MOS Category Name and sum up the monthly data. Then take the output of the the summarize tool and union it back to the main workflow. From there you'll sort it back on the MOS Category Name. Below is an example of one that I had created to give the detail with the Sub Total for a category and the Grand Total.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
please share the sample input in excel format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much for all your answers, especially for responding so quickly!
@CoG your workflow worked perfectly!
I Added an extra "Rig Total" line
Thanks again!
