Work Day values in the Pivot Table do not match the work day values in the worksheet. Some entries in worksheet show less than a full day (e.g: 0.75 of a day vs. 1 day).
I tried to use the cell format function the Pivot Table, but that did not work.
How do I get Pivot Table to show values < 1 day in decimal format?
Sample below.
Thank you.
<tbody>
</tbody>
I tried to use the cell format function the Pivot Table, but that did not work.
How do I get Pivot Table to show values < 1 day in decimal format?
Sample below.
Thank you.
Worksheet Values (Days) | Pivot Table Values (Days) | Pivot Table should Show | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
0.25 | 1.00 | 0.25 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
0.75 | 1.00 | 0.75 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.00 | 1.00 | ||
1.00 | 1.0 | 1.00 | ||
1.00 | 1.0 | 1.00 | ||
0.50 | 1.0 | 0.50 |
<tbody>
</tbody>