Hi! i need to create a row at the end of the table to sum values of each column. The rows and columns are dynamic, they change every day. I already did the column with totals, but could not do the row with totals (green line).
Please see below an example of what i need to do:
House | color | 2-Jan | 3-Jan | 4-Jan | total |
a | red | 50 |
|
| 50 |
b | blue | 100 | 50 |
| 150 |
c | brown |
|
| 25 | 25 |
d | yellow |
| 100 |
| 100 |
e | pink | 5 | 10 |
| 15 |
f | black |
|
|
| 0 |
TOTAL |
| 155 | 160 | 25 | 340 |
Thank you so much for the help!
Create a Summarize tool that sums the columns that you're after, then union back to the original file
Hi, @Camiiara
there is a workflow for you reference:
*********
Please mark it as a solution if can help you get expected result.
Find attached a very easy way of doing this.
Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.