Count Employees that's not affected by filters

[#1]

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.

[Frank_Hartmann]

please share a sample qvw which demonstrates the problem

[Digvijay_Singh]

Can you try this -

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

[Anil_Babu_Samineni]

Or this?

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