Bar Chart One Sum Dimension and add Average Dimension Bar

[Peter_Brunner]

Hi,

I don't know if it is possible but I need to display an extra Bar Column or Dimension in Bar Graph with an Average over all Sales

I have tried many different approaches with no luck!

I have attached an example with more detail

appreciate help on this

regards Peter

[sunny_talwar · Accepted solution]

May be further fine tuned, but look at the attached

[Peter_Brunner]

Hi Sunny,

First thank you for this impressive work, I have applied this to my "Main Structure" with many Records and other graphs and it is running very slow to update. Can you please explain in brief how the

1) Dimensions and Expressions work together e.g: the Pick and Dim?

2) If(GetSelectedCount(Rep) = 0, Sum(Sales)/Sum(TOTAL <Rep> Sales)/2, :  your /2 at the end of this line in expression is this to get average of Rep count?

I might see if I can speed the query up on my Main , I may have missed something.  maybe I need to group data in aggregated table just for this chart to be displayed?

regards Peter

[Peter_Brunner]

Hi Again Sunny ,

I have marked your answer correct, after doing a search I found another Discussion of yours ... link for an Explanation on your Pick, Dim structure here

Average help

and after looking at my Data Model  again and a restructure it runs as expected exactly what I wanted great work Sunny

and Thanks

regards Peter