14 Replies Latest reply: Sep 23, 2016 8:19 AM by Harleen Singh RSS

    repeating aggr value in straight table

    Harleen Singh

      I Have a straight table like this. I want to repeat values in a column which is total of Asia+America using expression

       

      let say if i use this formula  aggr( count(distinct EmpID),Year). it only returns one value .i.e 35 and 70 but doesn't repeat same in all the columns?

       

      Any ideas?

       

         

      YearRegion HeadcountTotal
      2016Asia1535
      2016America2035
      2015Asia3070
      2015America4070

       

       

      thanks