How to do a Group 1 Maximum?
HI I have several fields that are formulas and need to do a Group 1 Max on all of them but surpress the details and am not sure of this.
Zack Hasanov replied
In the details section, right-click on each field you wish to create a maximum subtotal on -> select insert summary -> under calculate summary, choose Maximum -> under Summary location, choose Group 1 Footer. This will give you the maximum for the field. Repeat each step for your other fields as well.
After this is done, right click on the details section on the left hand panel and choose suppress.
I hope this helps,