Sum columns based on column headers
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
Klachner
7 - Meteor
‎02-27-2024
07:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can someone help me sum data in columns based on column header names. I've attached an excel example
Labels:
5 REPLIES 5
binuacs
21 - Polaris
‎02-27-2024
08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Klachner use the dynamic select tool to get the column total. You can use the sample workflow attached
‎02-27-2024
08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks binuacs, is there a way to sum the jurisdiction by invoice number. attached an example.
Raj
16 - Nebula
‎02-27-2024
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Klachner just Group by the invoice no in the summarize tool before calculating the sum
you will get the result required.
binuacs
21 - Polaris
‎02-27-2024
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nagakavyasri
12 - Quasar
‎02-27-2024
11:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
