Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
HAmzehAF
Partner - Creator
Partner - Creator

sales above or below averge per month

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 ) 

111871_pastedImage_0.png

1 Reply
Chanty4u
MVP
MVP

Try this

Sum(Sales) - Avg({<Month=>} TOTAL <Month> Sales)