Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
please share a sample qvw which demonstrates the problem
Can you try this -
=sum({1<dept={'IT'}>}aggr(sum({1<dept={'IT'}>}Empid), Empid))
Or this?
sum(aggr(sum({1<dept={'IT'}>}Empid), Empid))