Hi,
I have a data set that is grouped by a Unique ID and Month. I would like to the Total Balance and Average Balance fields to display the difference between the two months. Please see example below.
Input:
| ID | Month | Total Balance | Average Balance |
| 01 | May | 5,000 | 2,000 |
| 01 | June | 7,000 | 6,000 |
Desired Output:
| ID | Total Balance | Average Balance |
| 01 | 3,000 | 4,000 |