Top 5 parts failures for the month of Aug

[#1]

how to display data only for the month of august,as am writing in expression as count(month),so it will take all the 12 months

[swuehl]

Try using

=count( if(month = 'Aug', month))

or using a set expression

=count({<month = {Aug}>} month)