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?