Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Remove the subselections using a set modifier. eg for "Clients in State picked":
=Count({<Industry=>}DISTINCT ClientID)
-Rob
Hi David,
1.=Count({<State=,Industry=>} distinct client)
2.=Count({<Industry=>} distinct client)
3.Count(distinct client)
are those what you want?
Aiolos