This seems like such a simple idea, I'm surprised I can't find a way to
handle it...

Period Cust Flag Prov
200805 123 Y ON
200805 234 Y ON
200805 345 N ON
200805 456 Y BC
200805 567 N BC

I've built a pivottable on the data above, with Period forming the rows,
Prov and Flag the columns, and Count of Cust in the data section. For
200805, in ON I see 2 customers with flag=Y and 1 with flag=N. In BC, I see
1 customer with flag=Y and 1 with flag=N.

I would like to see each of these values as a percentage of the values
within that province and period. For example, for 200805 in ON I'd like to
see 67% and 33%, in BC, I'd like to see 50% and 50%.

I've tried to use the field settings, and I can show these figures as
percentages of the row or column total, but not as percentages of the number
within the period and province. I can move the province field from a column
to a row, and then display percentage of row total, but the layout isn't
condusive, because there are lots of provinces and periods.

It strikes me as a simple request, to see the count of some value within all
possible values for that field, as a percentage. I've convinced myself that
I'm just missing the right function or field setting.... Is there a
solution?