Guidance on Sales Person v Team Average

[pkelly]

Hi All

Looking for some guidance on charts...

I have data similar to the following...

The user will filter on a sales person e.g. Paul Kelly.

I will show a summary of sales by product type for this sales person - straightforward.

What I would like to do beside this is show the average sales data for the users in the sales team in this example Panels.

Bearing in mind that we will have filtered on the user Paul Kelly, how do I ignore this filter (assuming set analysis) and show the average sales for the sales team that the filtered user belongs to?

Any assistance greatly appreciated.

Regards

Paul

[petter]

Sum for the team could be calculated in either of these ways:

Sum( {1} TOTAL  <SalesTeam> Value)      // When the SalesTeam occurs as a dimension in the chart

Aggr(NODISTINCT Sum( Value) , SalesTeam )  // When the SalesTeam does not occur as a dimension...

[sunny_talwar]

Not sure what type of object you are planning to use, but may be you can explore something like this:

Avg({<[Sales Person] = , [Sales Team] = p([Sales Team])>} Value)