Turns out I was selecting the wrong ID field! D'oh!

I have a field I need averaged
The report should look like:

Report for ID
Avg Avg Avg
Month Category Value1 Value2
6/2017 500 12.50 30.00
7/2017 550 15.00 30.00
8/2017 550 16.20 33.50
Using this syntax:
TABLE FILE
SUM
AVE.Category
AVE.Value1
AVE.Value2
BY ID
BY Month

I'm getting the median value for Category for ID, not the average Category per Month.

Any help is greatly appreciated!

Thanks,
Deb

This message has been edited. Last edited by: DWaybright,

Not sure if I understand but you may want to try the WITHIN syntax. Something like:

AVE.Category WITHIN MONTH