Hello! First time poster, semi-advanced.

I have a sheet of data that contains payment types, dates and amounts. I'm using a pivot table to :
1. Show me the breakout of payments made by day.
2. Sum those payments per day.
3. Sum & Max of those payments by month.
4. Count & Max of those payments by year.

It's beautiful. However, I need to find the largest daily sum for the year, and the largest monthly sum for the year. So, the max of the sums.

Even if it means dropping a second (mirrored) table that removes most of the stuff above. Or can specific results fields be made to populate a new table on the same page?

Is this possible?

Note: It's not as easy as writing a formual because I have to do this for 30ish customers and each will have a different number of payments on each day/month. The results field will be in a different place each time.

Thank you,
Shannon