Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
im trying to use this
sum(SALE)-(sum(total SALE))/count( total distinct Month)
to get this effect
but im using a drilldown ( month - day )
how can i do it ??
im trying to do ( sales above or below averge per month )
Try this
Sum(Sales) - Avg({<Month=>} TOTAL <Month> Sales)