Set Analysis - Pivot Table

[#1]

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

[swuehl · Accepted solution]

Try the TOTAL qualifier ,something like

=count(z) / count(total<x> z)

[#3]

Thank you so much!