Help

Get Averages and Totals by Month and Overall

1628 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron_Mittelman
6 - Interface Innovator
6 - Interface Innovator

I have a base to keep track of my gas expenses and want to get statistics. The one table I have has these fields:
Date
Gallons
$ per gallon
Total (calculated as Gallons * $ per gallon)
Month-Year (calculated as YEAR(Date) + “-” + MONTH(Date))…I know, it should really be called year-month.

If I group it by Month-Year, I can see totals per month, average price, etc.
But I would like to have another table that gives the statistics at a glance. Is it possible to present the totals in a new table like:



2017-5 $55.00
2017-6 $37.00
2017-7 $28.00


Avg Overall: $42.00

That way I could see at a glance how things are going month-by-month.
Any ideas how to do that?

Thanks…

0 Replies 0