SOLVED
Sum the column and add new row
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Thiviya
8 - Asteroid
‎10-24-2023
07:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
5 REPLIES 5
ShankerV
17 - Castor
‎10-24-2023
07:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-24-2023
07:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Attached the output results. The highlighted is what i would like to see
ShankerV
17 - Castor
‎10-24-2023
08:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Thiviya
Step 1: Summarize tool
Field - Differences
Action - Sum
Output Field Name - Differences
Step 2: Formula tool
Outout Column - Acct Descr
"Total"
Step 3: Union tool
Auto Config by Name
This will help you to get the expected result.
Many thanks
Shanker V
‎10-24-2023
09:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks
‎10-24-2023
09:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. It worked
