Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?/
Hi,
You can use count.
Have Gender as Dimesion.
Count(Distinct [emp id]) as expression
Celambarasan
Hi,
You can use count.
Have Gender as Dimesion.
Count(Distinct [emp id]) as expression
Celambarasan
how do we decide what to choose as a dimension and what to keep in expression?
Hi,
If we need the results based on some category means then that category will be the dimension.
Celambarasan
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.