Show data by top or bottom # values


I’m trying to retrieve top 5 customers by a calculated field.
In my field well I have:
Group by part - customerName & transactionDate(Month)
Value part - MTD_Amount_diff which is calculated the difference between month to date amount current month vs previous month.

then I’m trying to add a filter on customerName of top 5 values by MTD_Amount_diff and it doesn’t appear under the fields options.

I’ll appriciate your thoughts. How can I filter on top # values on an metric that I also present in the visual?


So you’re saying you can’t see the field in this dropdown?

correct. I don’t see it.

I don’t think you can use difference calculations (percentDifference, lag, lead, …) in a top and bottom filter.

Can you move the MTD_Amount_diff to SQL?

If so, then you should be able to filter based on that field.

I’ll try that, thanks

1 Like