Forum Discussion
Finding Max Value grouped by month
Hi,
I would like to sum the amount and group it by month filtering for the person. I would then like to find the max amount by month for each person. I only have data shown in the year 2017, but my data is over multiple years. I don't know if that makes a difference for the formula but wanted to give that information as well.
Can someone help me with this situation?
| Person | Amount | Date |
| James | 4500 | 2/1/2017 |
| James | 7500 | 2/1/2017 |
| James | 1000 | 7/1/2017 |
| James | 2400 | 8/1/2017 |
| Bob | 6500 | 2/1/2017 |
| Bob | 6000 | 6/1/2017 |
| Bob | 5500 | 8/1/2017 |
| Joe | 300 | 7/1/2017 |
| Joe | 2000 | 7/1/2017 |
| Joe | 4000 | 9/1/2017 |
| Chance | 600 | 6/1/2017 |
| Chance | 800 | 9/1/2017 |
| Steve | 200 | 7/1/2017 |
| Steve | 350 | 7/1/2017 |
| Steve | 720 | 10/1/2017 |
| Trevor | 600 | 8/1/2017 |
| Trevor | 7000 | 12/1/2017 |
| Brian | 2500 | 7/1/2017 |
| Brian | 3000 | 7/1/2017 |
| Brian | 5000 | 11/1/2017 |
The desired outcome should be
| Person | Total | Max |
| James | 15,400 | 12,000 |
| Bob | 18,000 | 6,500 |
| Joe | 6,300 | 4,000 |
| Chance | 1,400 | 800 |
| Steve | 1,270 | 720 |
| Trevor | 7,600 | 7,000 |
| Brian | 10,500 | 5,500 |
Any advice you can give me is much appreciated. Thank you in advance!
1 Reply
- Ashish_Mathur
Super User