Conditional show in list box

[Anonymous]

Hi,

Please export list box(Employee names) and check count .

=Aggr([Employee Name],[Employee Name]) use this expression for list box. next check Hide Excluded.

Next click on Q4 or Q3 or Q2 or Q1. next export Employee names(List Box) to Excel. next check count.

Q4 count is 6054

Q4 Excel count is 6136.(Employee Names)

Thanks,

Krishna

[MK_QSL]

If you want to match Employee Name count then you have to use below expression

=COUNT(DISTINCT [Employee Name])

[Anonymous]

Hi Manish,

=COUNT(DISTINCT [Employee Name]) this Expression returns 0 values.

Thank

Krishna

[agni_gold]

You are making Average count in chart , but in list box it will not show avg values.

If you want count match then you need to use text box , see in attached file.

[MK_QSL]

This expression you have to use in Bar Chart... Not in List Box