Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need Top 20 records based on measure value in table view.
1 dimension and 3 measures.
Dimension: Customer
Measure 1: Calls
Measure 2: Total Calls
Measure 3: Conversion %
Need top 20 based on Measure 3, though I got top 20 using this formula
If(Rank(measure, 1, 0) <= 20,measure)
Using this formula I get top 20 but I also get null values for rest of the records, how do I remove thoes nulls values and only showcase top 20 records.
Thank you in advance!
@premacharya0903 Like this ?
= Aggr ( If(Rank(measure, 1, 0) <= 20, Customer, 'Others') , Customer)