Set Analysis in Gauges

[buddhabang]

Hi,

I had a question if anyone could please help me with a set analysis i'm using in a gauge. I have a list of departments and calculated the number of employees in each one of these and wanted to get the ratio per dpt. My problem is this following set A in the gauge expression that only works for just the marketing dpt:

(count({$<Department={Marketing}>}Employee_ID)*100)/count(DISTINCT Employee_ID)

I want to be able to get the ratio for each individual department. Any help would be much appreciated.

Thanks

[buddhabang]

Cheers Mark, i will check this tomorrow at work, i'm using the PE at the moment at home. Thanks a lot guys for your help.

For the numbers i use in the text in chart expression field:

=num((count({$<Department={Marketing}>}Employee_ID)*100)/count(DISTINCT Employee_ID),'#.##')&'%'

Nice one

[buddhabang]

Thanks guys for helping me out with this, i really appreciate it.

Cheers.