Avg Sales Per Month

[HAmzehAF]

how to do a (sales above or below averge per month ) bar chart

 i want to do like this chart to show above the avg or below the avg 

any help?

[pravinboniface]

@HAmzehAF It looks like you want to take an average over the entire period and then showing the difference vs each month.  Can you try the following please?

sum(Sales) - avg(Total Sales)

[HAmzehAF]

hello,
i already did that but i want to get it like the table in the pic above :
sales above or below averge per month

[pravinboniface]

@HAmzehAF The initial picture looks like it has a dimension of month and then you need 2 measures.  One is 

sum(Sales) - avg(Total Sales)

The other is sum(Sales)

[Chanty4u]

Try this

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

Already repied on other post please have a look