Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm creating a pivot table with two dimensions X and Y and then I'm doing counts of Z. But what I really want to be doing is percentages with respect to X. So my expression would be Count(X=x and Y=y, Z) / Count(X=x, Z). I've tried to do: Count(Z) / (Count({$<Y=>} Z), but that just returns 100% for everything.
Any help would be appreciated.
Thanks,
Rebecca
Try the TOTAL qualifier ,something like
=count(z) / count(total<x> z)
Thank you so much!