Row count based on selections

[Anonymous]

I have a straight table with about 17 000 records.  I have created a textboox with a Count(Distinct(TradeName)) which counts the number of distinct TradeNames in the straight table as is illustrated below:

The distinct count of TradeName gives a value of 3801 as illustrated above.  I would want this value to change based on various selections with various dimension values for example filter by date which should reduce the number 3801.

How can this be accomplished in QV?

[Anonymous]

Agree with Bill, it should be: Count ( Distinct ( [FDA TradeName] ) )

[Anonymous]

You are right Roger, i have another model within the same application with TradeName and so i had picked up the wrong field for that model.

Once again thank you all.

[Anonymous]

Thank you are right as pointed to Roger

[Anonymous]

Thanks Balraj most appreciated