Hi All,

I have column with "y" and "n"

TL
y
n
y
y


I want to apply the formula in Pivot table Like "=countif("TL Column","y")/counta("TL Column")

Is it possible to apply countif formula in pivot table formulas, if yes please post a proper syntax for how to apply this?

Thanks,
lavi