Compare sales of each region with the average sales of all regions on bar chart

[youss123]

Hi all,

I have a bar chart that displays average sales by region.

I want to make in  all the bars a point that displays the average of all regions.

I explained more in the draw attached,

Thank you in advance.

 

[Taoufiq_Zarra · Accepted solution]

@youss123  if I understood correctly

in averge you need to use total like

avg(total sales)

[youss123]

it worked. thank you very much