Input:
Expected output:
I want to SUM the Totals below the current one. I'm a new user and i'm stuck with the multi-row formula.
Thank you.
Solved! Go to Solution.
You can actually take advantage of the running total for this! You'll just need to reverse the order of your data.
I started by adding a record ID, so I'd know the order of the data. I used a sort to reverse the order. I then used a Running total to calculate the subtotal, and then another sort to put my data back in the original order. A select renamed the column to subtotal.
User | Count |
---|---|
105 | |
82 | |
70 | |
54 | |
40 |