Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Count(DISTINCT Letter)/Count(TOTAL DISTINCT Letter)
I try with dimensionnalty() function for Total in pivot chart (learn from Sunny T!)
if(Dimensionality()=0,Count({<Value-={""}>} Letter) / Count(Letter),sum(Value))
Sorryn in order to keep the Value1/Value2 representation it's :
if(Dimensionality()=0,Count({<Value-={""}>} Letter)&'/'& Count(Letter),sum(Value))