count in a pie chart

[#1]

hi

i have 3 list boxes name,emp id, and gender. i want to show the total no of male emp and female emp in pie chart.

can count be used for it??

if yes waht would be the syntax for it?/

[CELAMBARASAN · Accepted solution]

Hi,

     You can use count.

     Have Gender as Dimesion.

     Count(Distinct [emp id]) as expression

Celambarasan

[#3]

how do we decide what to choose as a dimension and what to keep in expression?

[CELAMBARASAN]

Hi,

     If we need the results based on some category means then that category will be the dimension.

Celambarasan

[jagan]

Hi,

The static values Like Department, Year, Month, Country, City like values are used as dimension.

The calculated values are used as expression.  For example

=Sum(Sales)    - Total Sales

=Count(Employees) - Count of employees

Hope this helps you.

Regards,

Jagan.