count values in row of a pivot table greater than the average of the values in that row

Hello All,

I'm new to the forum and any help is greatly appreciated! My issue is trying to count the values in a row of a pivot table greater than the average of all the values in the same row of the pivot table. I'm using the countif and counta in my formula, but must be missing something.

Thank You

Something like

=COUNTIF(A1:A100,">"&AVERAGE(A1:A100))