How do I display a field's values in 3 columns in a Straight Table ?

[#1]

Hi,

As a QV newbie I am trying to build a dashboard with a Straight Table screen object showing the number of personnel (male and female) in each Department. The source data consists of fields which include Employee Name, Department, Gender. The values in the Gender field can only be 'Male' or 'Female'.

If I use Gender as the dimension it just gives me the total of employees for each Department. How can I show the split in Gender across two columns in my Straight Table, like so...

Department	Male	Female	Total
Human Resources	20	24	44
I.T.	17	8	25
Finance	10	6	16

Thanks in anticipation

MV

[MK_QSL]

Count({<Gender = {'Male'}>}Employee)

Count({<Gender = {'Female'}>}Employee)

Count(Employee)

Or

Count({<Gender = {'Male'}>}Distinct Employee)

Count({<Gender = {'Female'}>}Distinct Employee)

Count(Distinct Employee)

[yduval75]

Department as dimension

and three expressions like this :

- Count ({<Gender={'Male'}>} Distinct Employee)

- Count ({<Gender={'Female'}>} Distinct Employee)

- Count (Distinct Employee)

[#4]

Wow ! That was a quick response.

What happens here ? Both answers are the same. Who do I give the Correct Answer to ?

[MK_QSL · Accepted solution]

First Come First Serve !

Just Kidding... It's up to you...

You can obviously make one correct and helpful... !

[yduval75]

Indeed Manish is the first

A correct for Manish and an helpul for me will be nice

[its_anandrjs]

One more explanation lets see

You have to use like

In straight table

Dimension:- Department

Expression1:- Count(DISTINCT {<Gender = {'Male'}>}[Employee Name])

Expression2:- Count(DISTINCT {<Gender = {'Female'}>}[Employee Name])

Expression3:- Count([Employee Name])

You can use DISTINCT key word also for count

Regards