Showing different totals in either text box or chart

[#1]

I have the following selection boxes:

1  Client or Non Client

2.  Listing of States

3.  Listing of Markets

My Desirable Results:

1.  A chart or text box that shows, as example, 400 Clients when someone selects client.

2.  A chart or text box that shows, as example, 300 Clients when someone selects lets say TX but does not change the chart or box for client at 400.

3.  A chart or text box that shows, as example, 200 Clients when someone selects lets say Public K12, which is one of our markets, but does not change the chart or text box for client or for state.

Does this make sense and can it be done?

David

[rwunderlich]

Remove the subselections using a set modifier. eg for "Clients in State picked":

=Count({<Industry=>}DISTINCT ClientID)

-Rob

http://masterssummit.com

[uacg0009]

Hi David,

1.=Count({<State=,Industry=>} distinct client)

2.=Count({<Industry=>} distinct client)

3.Count(distinct client)

are those what you want?

Aiolos