Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a set expression where it calculates only Names that have an Aggr count within a range
For example below - If I only wanted to calculate a measure for names to which only have a total count value of > 4, then only Steve would be included.
What am I doing wrong ? Thanks !!
Steven(5) Sean(3)
H1234 E9384
H5678 E9393
H6656 E334
H9989
H9445
Can you share your qvf file to look into?
What you shown in image wrong.. But, Try to explain your needed
May be this
Count({1<[PCP Full Name] = {"=Count(PCPanel) > 2000"}>}PVPanel)
Hi Sunny,
Appreciate the response - but that only works on the selection.
I want this expression to look at all the names - irregardless of the current selection.
I'm think the aggr function needs to be involved.
Extending Sunny's expression may be you can try like below?
= Count({1<[PCP Full Name] = P({< [PCP Full Name] = {"=Count(PCPanel) > 2000"} >} [PCP Full Name]) >} PVPanel)
May be, but don't really have enough information to know what you have and what you might need... would you be able to share a sample?