where clause on expressions

[#1]

Hi There,

I need to generate 3 expressions that each have a different where clause bases on employee average age, female employee average age and male average age.

How can I used a where clause in an expression pivot table?

E.G.

Group Name Employee Avg Age Female Avg Age Male Avg Age
Group1 33.3 24.5 40.3
Group2 35.5 34.8 33.7

My detail contains employee number, gender and DOB.

Thanks,

Kevin.

[#2]

Expression for

Female Avg Age =Avg( {$<Gender='Female'>} Age)

Male Avg Age = Avg( {$<Gender='Male'>} Age)

Try Employee Avg Age your self.