Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Help me, please
I have a table with one dimension and one expression:
1)
2)
the result looks like this:
And now I need only the rows of the table with a certain value = 157.
I add this condition...
and result looks like this:
Help me, please ;((((((((((((((((
Write:
If(Count(Distinct SYSAGID)= 157, Count(Distinct SYSAGID), 0)
And in presentation tab verify the default "Suppress zero values"
But if you need values from other fields you must use however aggregated function so:
If(sum(otherfield) = 157, count(distinct SYSAGID), 0)
Hope it helps
count({<FieldWithValue={157}>}DISTINCT SYSAGID)
Write:
If(Count(Distinct SYSAGID)= 157, Count(Distinct SYSAGID), 0)
And in presentation tab verify the default "Suppress zero values"
But if you need values from other fields you must use however aggregated function so:
If(sum(otherfield) = 157, count(distinct SYSAGID), 0)
Hope it helps