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:
<tbody>
</tbody>
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!
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:
| Row Labels | Region 1 | Region 2 | Region 3 | Region 4 |
| Jul | 20% | 30% | 9% | 50% |
| Aug | 3.5% | 7% | 25% | 2% |
| Sep | 80% | 90% | 56% | 3% |
| Oct | 10% | 26% | 70% | 40% |
<tbody>
</tbody>
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!
