Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all pls find the attached App,My requirement is to get the mention result days wise.
Thanking You
Vinayagam
=SUM(TOTAL <Centre,State> PO)/COUNT(TOTAL <Centre,State> DISTINCT Date)
Thanks Sir
But if u see the subtotal at state level it shows its different
COULD BE THIS?
=avg ( AGGR (SUM(TOTAL <Centre,State> PO)/COUNT(TOTAL <Centre,State> DISTINCT Date) , Date, Centre, State))