I know how to do normal calculated fields inside a pivot table and think what I want to do is not just a simple calculated field.
<colgroup><col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;">
<col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;">
<col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;">
<col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5449;">
<col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2">
<tbody>
</tbody>
I want to produce a pivot table that shows the difference between 7's + 8's values. 7 and 8 represent the hour of the day that calls occurred. I have hours from 1 to 24. there are different types, groups and departments....so nota simple view when done
so base on he above values we can manually calculate the differences
<colgroup><col width="64" style="width: 48pt;" span="3">
<col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;">
<tbody>
</tbody>
since the calculation would use "Day" column vest the values of Previous and current inside the day column, I think this is going to take yucky looking creativity to make happen.
any thoughts on how I cold get a pivot that looks like
<colgroup><col width="64" style="width: 48pt;" span="2">
<col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;">
<col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;">
<col width="64" style="width: 48pt;" span="7">
<tbody>
</tbody>
| Department | Group | Day | Data Type | 7 | 8 |
| BE Hourly | Chrysler | Current | Service Level - % 20 | 100.00% | 91.67% |
| BE Hourly | Chrysler | Previous | Service Level - % 20 | 98.92% | 91.67% |
I want to produce a pivot table that shows the difference between 7's + 8's values. 7 and 8 represent the hour of the day that calls occurred. I have hours from 1 to 24. there are different types, groups and departments....so nota simple view when done
so base on he above values we can manually calculate the differences
| Hour | Previous | Current | Difference |
| 7 | 98.92 | 100 | -1.08 |
| 8 | 91.67 | 91.67 | 0 |
since the calculation would use "Day" column vest the values of Previous and current inside the day column, I think this is going to take yucky looking creativity to make happen.
any thoughts on how I cold get a pivot that looks like
| Department | Group | Data Type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| BE Hourly | Chrysler | Service Level - % 20 | -1.08% | 0.00% |
