Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
is it possible to count by month and Total would be Average?
This?
Sum({<Period=,Period={'<=$(=max(Period))'}>}aggr(sum({<Period=,Period={'<=$(=max(Period))'}>}data),Yr, mnth))/Count({<Period=,Period={'<=$(=max(Period))'}>}DISTINCT Yr)
THANK YOU!
I would have not figured this out with out your expertise.