SetAnalysis in a Pivot Table

[seband_fredes]

Hi everyone,

I've this pivot table:

The Pivot Table's expression is a Count, and I need to calculate this result:

Have anyone some solution for this?

Thanks

[sunny_talwar]

May be this

Count(DISTINCT Letter)/Count(TOTAL DISTINCT Letter)

[sergio0592]

I try with dimensionnalty() function for Total in pivot chart (learn from Sunny T!)

if(Dimensionality()=0,Count({<Value-={""}>} Letter) / Count(Letter),sum(Value))

[sergio0592]

Sorryn in order to keep the Value1/Value2 representation it's :

if(Dimensionality()=0,Count({<Value-={""}>} Letter)&'/'& Count(Letter),sum(Value))