3 Replies Latest reply: May 15, 2017 12:22 PM by Anil Babu RSS

    Count Employees that's not affected by filters

    abby sal

      Hi, I have an expression which goes like this:

      =sum({1}aggr(sum({<dept={'IT'}>}Empid), Empid))

       

      I was hoping to count employees under IT department which does not change regardless of the selection. i tried adding {1} before aggr but it still change. I also tried adding before Empid of Sum but it counts everything, disregarding my set analysis.. Thank you in advance for the help.