3 Replies Latest reply: Aug 13, 2014 2:20 PM by Jaime Aguilar RSS

    aggr in pivot table not showing in all rows

    Oscar Marquez

      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)

       

      Capture.PNG.png