line level count and avg at total is it possible?

[rmuhammad]

Hi All

is it possible to count by month and Total would be Average?

[sunny_talwar · Accepted solution]

This?

Sum({<Period=,Period={'<=$(=max(Period))'}>}aggr(sum({<Period=,Period={'<=$(=max(Period))'}>}data),Yr, mnth))/Count({<Period=,Period={'<=$(=max(Period))'}>}DISTINCT Yr)

[rmuhammad]

THANK YOU!

I would have not figured this out with out your expertise.