Spreadsheet: 868080d1714773387-calculated-pivot-field-lunch-help
Sheet: Pivot

 | Column Labels
 | 2024-04-01 00:00:00 |  |  |  | 2024-04-02 00:00:00 |  |  |  | 2024-04-03 00:00:00 |  |  |  | 2024-04-04 00:00:00 |  |  |  | 2024-04-05 00:00:00 |  |  |  | 2024-04-08 00:00:00 |  |  |  | 2024-04-09 00:00:00 |  |  |  | 2024-04-10 00:00:00 |  |  |  | 2024-04-11 00:00:00 |  |  |  | 2024-04-12 00:00:00 |  |  |  | 2024-04-15 00:00:00 |  |  |  | 2024-04-16 00:00:00 |  |  |  | 2024-04-17 00:00:00 |  |  |  | 2024-04-18 00:00:00 |  |  |  | 2024-04-19 00:00:00 |  |  |  | 2024-05-01 00:00:00 |  |  |  | 2024-05-02 00:00:00 |  |  |  | Total Sum of Non Lunch Pay | Total Sum of Lunch NP | Total Sum of Short Lunch | Total Sum of Lunch Test
Row Labels | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test
[NAME], [NAME] |  |  |  | 0 | 6.83 | 0 | 1 | 1 | 7.699999999999999 | 1 | 0 | 1 | 8.37 | 1 | 0 | 1 | 7.72 | 1 | 0 | 1 | 7.85 | 1 | 0 | 1 | 7.93 | 1 | 0 | 1 | 8 | 1 | 0 | 1 | 7.02 | 1 | 0 | 1 | 7.73 | 1 | 0 | 1 | 8.27 | 1 | 0 | 1 | 7.58 | 1 | 0 | 1 | 7.52 | 1 | 0 | 1 | 7.77 | 0 | 1 | 1 | 5.800000000000001 | 0 | 0 | 0 | 8.05 | 1 | 0 | 1 | 7.6 | 1 | 0 | 1 | 121.74 | 13 | 2 | 1
Doe, [NAME] | 1.4 | 0 | 0 | 0 | 8.57 | 0 | 0 | 1 | 7.83 | 0 | 1 | 1 | 8.129999999999999 | 1 | 0 | 1 | 8.25 | 0 | 1 | 1 | 8.18 | 0 | 1 | 1 | 8 | 0 | 1 | 1 | 8.120000000000001 | 0 | 1 | 1 | 8.03 | 0 | 1 | 1 | 8.5 | 0 | 0 | 1 | 8.13 | 1 | 0 | 1 | 7.869999999999999 | 0 | 1 | 1 | 5.78 | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0 | 8.02 | 1 | 0 | 1 |  |  |  | 0 | 104.81 | 3 | 7 | 1
Grand Total | 1.4 | 0 | 0 | 0 | 15.4 | 0 | 1 | 1 | 15.53 | 1 | 1 | 1 | 16.5 | 2 | 0 | 1 | 15.97 | 1 | 1 | 1 | 16.03 | 1 | 1 | 1 | 15.93 | 1 | 1 | 1 | 16.12 | 1 | 1 | 1 | 15.05 | 1 | 1 | 1 | 16.23 | 1 | 0 | 1 | 16.4 | 2 | 0 | 1 | 15.45 | 1 | 1 | 1 | 13.3 | 1 | 0 | 1 | 7.77 | 0 | 1 | 1 | 5.800000000000001 | 0 | 0 | 0 | 16.07 | 2 | 0 | 1 | 7.6 | 1 | 0 | 1 | 226.55 | 16 | 9 | 1