Spreadsheet: 868502d1715221238-calculated-pivot-field-lunch-help-alo2279-
Sheet: Pivot

 | Column Labels
 | 2024-04-01 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-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-05-01 00:00:00 |  |  |  |  | 2024-04-18 00:00:00 |  |  |  |  | 2024-04-19 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 | Total Sum of % Lunch Taken
Row Labels | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken | Sum of Non Lunch Pay | Sum of Lunch NP | Sum of Short Lunch | Sum of Lunch Test | Sum of % Lunch Taken
[NAME], [NAME] |  |  |  |  | #[NAME]! | 8 | 1 | 0 | 1 | 1 | 7.02 | 1 | 0 | 1 | 1 | 7.73 | 1 | 0 | 1 | 1 | 8.27 | 1 | 0 | 1 | 1 | 7.58 | 1 | 0 | 1 | 1 | 7.52 | 1 | 0 | 1 | 1 | 6.83 | 0 | 1 | 1 | 0 | 7.699999999999999 | 1 | 0 | 1 | 1 | 8.37 | 1 | 0 | 1 | 1 | 7.72 | 1 | 0 | 1 | 1 | 7.85 | 1 | 0 | 1 | 1 | 7.93 | 1 | 0 | 1 | 1 | 8.05 | 1 | 0 | 1 | 1 | 7.77 | 0 | 1 | 1 | 0 | 5.800000000000001 | 0 | 0 | 0 | #[NAME]! | 7.6 | 1 | 0 | 1 | 1 | 121.74 | 13 | 2 | 15 | 0.8666666666666667
Doe, [NAME] | 1.4 | 0 | 0 | 0 | #[NAME]! | 8.120000000000001 | 0 | 1 | 1 | 0 | 8.03 | 0 | 1 | 1 | 0 | 8.5 | 0 | 0 | 1 | 0 | 8.13 | 1 | 0 | 1 | 1 | 7.869999999999999 | 0 | 1 | 1 | 0 | 5.78 | 0 | 0 | 0 | #[NAME]! | 8.57 | 0 | 0 | 1 | 0 | 7.83 | 0 | 1 | 1 | 0 | 8.129999999999999 | 1 | 0 | 1 | 1 | 8.25 | 0 | 1 | 1 | 0 | 8.18 | 0 | 1 | 1 | 0 | 8 | 0 | 1 | 1 | 0 | 8.02 | 1 | 0 | 1 | 1 |  |  |  |  | #[NAME]! |  |  |  |  | #[NAME]! |  |  |  |  | #[NAME]! | 104.81 | 3 | 7 | 12 | 0.25
Grand Total | 1.4 | 0 | 0 | 0 | #[NAME]! | 16.12 | 1 | 1 | 2 | 0.5 | 15.05 | 1 | 1 | 2 | 0.5 | 16.23 | 1 | 0 | 2 | 0.5 | 16.4 | 2 | 0 | 2 | 1 | 15.45 | 1 | 1 | 2 | 0.5 | 13.3 | 1 | 0 | 1 | 1 | 15.4 | 0 | 1 | 2 | 0 | 15.53 | 1 | 1 | 2 | 0.5 | 16.5 | 2 | 0 | 2 | 1 | 15.97 | 1 | 1 | 2 | 0.5 | 16.03 | 1 | 1 | 2 | 0.5 | 15.93 | 1 | 1 | 2 | 0.5 | 16.07 | 2 | 0 | 2 | 1 | 7.77 | 0 | 1 | 1 | 0 | 5.800000000000001 | 0 | 0 | 0 | #[NAME]! | 7.6 | 1 | 0 | 1 | 1 | 226.55 | 16 | 9 | 27 | 0.5925925925925926