Dynamically Sum Columns with Headers that Contain Certain Text
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
yoyoumysin
6 - Meteoroid
‎01-28-2023
08:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to summarize incoming payment for some invoices as customers may make multiple partial payments. Note the Paid On Date may keep growing as new partial payments trickle in. For example:
Invoice # | Amount | Paid on 12-01 | Paid on 12-05 | Paid on 01-20 | Total Paid |
A001 | 10,000 | 5,000 | 2,500 | 500 | 8,000 |
A002 | 15,000 | 5,000 | 0 | 0 | 5,000 |
A003 | 17,500 | 7,500 | 10,000 | 0 | 17,500 |
Labels:
- Labels:
- Dynamic Processing
2 REPLIES 2
apathetichell
19 - Altair
‎01-28-2023
10:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
transpose
Invoice and amount are your key columns. make sure that unknown columns and the Paid on columns are clicked for columns to be transposed.
summarize tool.
group by invoice/amount
sum - Value columns.
The result (ie Sum_Value) is your total paid.
binuacs
21 - Polaris
‎01-29-2023
12:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
