Expression Help

[Anonymous]

I need a little bit of help editing an expression.  Attached you'll see and image of two straight tables.  In the second table, I've removed one employee category by putting a dimension in the expression

But the issue that I'm having now is that the formulas are still adding up all of the categories, instead of what is showing in the second document.  I suspect that there is some kind of Aggr that needs to be put in.

Employee Count expression is sum([Employee Count])

% of EE total expression is sum([Employee Count])/sum(TOTAL([Employee Count]))

Can anyone help me out?  Thanks!

[chrismarlow]

Are you saying you want to exclude one 'Employee Department', in which case would a set {<[Employee Department]-={'xxx'}>} do it?

[Anonymous]

Chris,

The point of the two charts is essentially to present the employee counts based on department - one with and one without HDS, rather than having someone have to actively select them from a list box.

I've already excluded the employee department in the second table by a simple =if([Employee Department]<>'
HDS',[Employee Department]). 

What is happening that I wasn't expecting, is that when calculating the % of total, it's still counting the HDS data.  I'm afraid I'm not versed in Set Analysis enough to understand a lot of that yet. 

[chiru_thota]

Exclude that department in bot numerator & denominator of % EE Metric also.

Otherwise upload your QVW.

[Anonymous]

uploaded

[chiru_thota · Accepted solution]

sum({<[Employee Department]-={'Help Desk Services'}>}[Employee Count])

/sum({<[Employee Department]-={'Help Desk Services'}>}TOTAL([Employee Count]))

[Anonymous]

Awesome.  Thanks!