Hi, I have the below example, in first table I have everything, but I need to show it like in the second one, only by SLS_MTRC_ID,
to count the total number of sales_territories I'm using this formula: aggr(count(SALES_TERRITORY_ID),SALES_EMPLOYEE_ID), which is giving me the correct figures 4 and 9, but why do they show up only for the first sales_metric dimension row of each employee?
Same for total Q by rep: aggr(sum(QUOTA_SALES_METRIC),SALES_EMPLOYEE_ID)
When using aggr you need to take care about the involved dimensions in your chart.
In the case of your example for the second chart you're creating a chart with SLS_MTRC_ID as dimension. then your formula should be something like this (it's what I can figure out just by seeing the screenshots):