How To Display Monthly Average...

[#1]

Hi,

Hope you can help me attain my DESIRED OUTPUT:

Given tables are:

CUSTOMER TARGET TABLE
SALES TRANSACTIONS

SALES TABLE below are just a summary of daily transaction grouped monthly.
What i need to be displayed is Monthly Average based on this group.

Please see illustration below:

Hope you can help on this matter.

Thanks in advance

Marson

[#2]

Hi,

Expression would be like below.

Sum(Sales) / Count(Distinct Month)
Untested Expression.

-Peterson

[#3]

Thank you for quick reply... I will check on this hope this is the one I'm looking for...