Pivot Tables: % not based on subtotal

[uceaamh]

Hello,

I'm hoping this is a silly question with an easy answer.

I'm attempting to make pivot tables represent monthly percentages based on yes/no data. My ideal output looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD]Region 1[/TD]
[TD]Region 2[/TD]
[TD]Region 3[/TD]
[TD]Region 4[/TD]
[/TR]
[TR]
[TD]Jul
[/TD]
[TD]20%[/TD]
[TD]30%[/TD]
[TD]9%[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD]3.5%[/TD]
[TD]7%[/TD]
[TD]25%[/TD]
[TD]2%[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD]80%[/TD]
[TD]90%[/TD]
[TD]56%[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]10%[/TD]
[TD]26%[/TD]
[TD]70%[/TD]
[TD]40%[/TD]
[/TR]
</tbody>[/TABLE]

Where the values are created out of a column which is filled with "yes" and "no" (I can change that to 1,0 or whatever value allows for %'s), based on whether a report got finished on time or not.

As you can see, those values don't add up to 100%, either in columns or rows. The available PivotTable options 'Show Values As' only allow for % based on subtotals.

I read you could do this via calculated field, but that option is grayed out when I attempt to put one in.

I thought it was because the data is from OLAP cubes, but apparently the data is pure excel.

Not sure what to do here. Any help would be appreciated.

Thanks!