Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=GetSelectedCount( X )
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)
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) & ')'
Great. Just the answer I was looking for 🙂