Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I count the number of values for a particular filter in the current filters box?

Cay I have a dimension called X, i want to count the number of values that were selected for x in the current filters box

4 Replies
swuehl
MVP
MVP

=GetSelectedCount( X )

fred_s
Partner - Creator III
Partner - Creator III

Hi Chris,


To be honest I don't understand your question.
Perhaps something like this?

To count the associated values
=count(X)

To count the unique associated values
=count(DISTINCT X)

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

another option would be putting this in the caption (in case you're using listbox as filter):

FieldName & '(' Count(Distinct FieldName) & '/' & Count(Distinct all FieldName) & ')'

Amit
Contributor III
Contributor III

Great. Just the answer I was looking for 🙂