How to get the number of rows by a condition

[Hide_Kojima1]

For example, if you want to get the number of records where the Sales column value is greater than 1000

Then you can create a Pivot Table like below, and create a chart filter with Sales > 1000

Then you’ll get the number of records where the Sales column value is greater than 1000