Passing arguments in count function?

[rohitians]

Hey,

I have following expression,

=count(DISTINCT SUBGROUP)

But i want the count for only a particular company for example COMPANY='XYZ'

please help.

Thanks.

[AbhijitBansode · Accepted solution]

=count({<COMPANY={'XYZ'}>}DISTINCT SUBGROUP)

[sujeetsingh]

Abhi , has given you the best way to do this. On the other hand you want the value passed to be dynamic means based on selection you can use variable as

vSelected=getfieldselected(COMPANY)

=count({<COMPANY=(=$(vSelected))>}DISTINCT SUBGROUP)

[rohitians]

Hey Thanks..