Warm tip: This article is reproduced from serverfault.com, please click

Top 10 cost where profit is < zero

发布于 2020-11-30 05:50:58

I have following table

I want to show top 10 products where profit is less than equal to zero.

Questioner
Narendra Suryawanshi
Viewed
0
mkRabbani 2020-11-30 14:45:29

Follow these below steps-

Step-1: Add a visual level filter with profit <= 0. For example check the below image.

enter image description here

Step-2: Add another filter with show TOP 10 on the value column. Check the below image for example-

enter image description here

You will get your desired output.