Cannot specify subtotals in report.
I was able to create a dynamic report from this table and it would total and subtotal correctly. Then I tried using the Report Assistant so I can save the report as a layout, and for some reason the field I want to total is greyed out. SERVICE AMOUNT (the field I am trying to total) has been defined as a number field, and did work correctly in the dynamic report.
SERVICE AMOUNT TOTAL must have been generated by the dynamic report I ran?
Can anyone shed any light on this?