Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a rank function that needs to ignore some fields, but not working. how can I ignore the filter using the rank function?
aggr(
if( rank
if(sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure)<>0,
sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure))
)<=5, only({<FIELD1>} Dim)),Dim)
If I included in the KPI only the sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure) the selection by FIELD1 will be ignored, this is ok, but using the full measure with rank not ignore
Maybe with Aggr({<FIELD1>} ... ?
first of all, thank you for your answer...
But not ignored yet.
if I selected a type of the FIELD1, show 3 values, but without this selection I will wait 5, because the rank without this selection is 5.
I'm tried
Only( {<FIELD1>}
aggr(
if( rank
if(sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure)<>0,
sum({<FIELD1,month={"11"}, flag={0}, field2,field3>} measure))
)<=5, Dim)),Dim))
But this retunr: Invalid dimension