Create a Rollup View in Airtable
Kate Ruff
83 steps
5 minutes
Airtable
1
Navigate to [https://airtable.com/appFRP7wWJIfRAYzE/pag2WIfimWO5HzZ0A/edit](https://airtable.com/appFRP7wWJIfRAYzE/pag2WIfimWO5HzZ0A/edit)
2
Click this button.
3
Click "Pivot table"
4
Click "None"
5
Click this icon.
6
Click this icon.
7
Click "Theme"
8
Click this icon.
9
Click "is exactly..."
10
Click here.
11
Click "Food Security"
12
Click this icon.
13
Click this icon.
14
Click "Headline Indicators"
15
Click this icon.
16
Click "is not empty"
17
Click this icon.
18
Click the "Title" field.
19
Type "Food Security"
20
Click "value"
21
Click "Headline Indicators"
22
Click "startedAtTime"
23
Click "endedAtTime"
24
Click "None"
25
Click "Year"
26
Click "Field"
27
Click "Sum"
28
Click "Sum"
29
Click "value"
30
Click "value"
31
Click the "Show label" field.
32
Click the "Show totals" field.
33
Click the "Show totals" field.
34
Click the "Show totals" field.
35
Click "Food Security"
36
Click "2022"
37
Click "2023"
38
Click "Food Security"
39
Click "Food Security"
40
Click "Food Security"
41
Click "2024"
42
Double-click "Food Security"
43
Click "2025"
44
Click "Food Security"
45
Click "Food Security"
46
Click "Headline Indicators2022202320242025SumTotal dollar value of food cost savings for community members40,055.140,055.1Total individuals gaining the..."
47
Click "Food Security"
48
Click "Food Security"
49
Click "Sum"
50
Click this button.
51
Click "Pivot table"
52
Click "None"
53
Click "Add condition"
54
Click this icon.
55
Click "Theme"
56
Click this icon.
57
Click "is exactly..."
58
Click this icon.
59
Click "Economic Vitality"
60
Click "Add condition"
61
Click this icon.
62
Click "Headline Indicators"
63
Click this icon.
64
Click "is not empty"
65
Click the "Title" field.
66
Click the "Title" field.
67
Type "Economic Vitality"
68
Click "value"
69
Click "Headline Indicators"
70
Click "startedAtTime"
71
Click "endedAtTime"
72
Click "None"
73
Click "Year"
74
Click the "Show label" field.
75
Click the "Show totals" field.
76
Click the "Show totals" field.
77
Click the "Show totals" field.
78
Click "Field"
79
Click "value"
80
Click "value"
81
Click "Sum"
82
Click this checkbox.
83
Click "Allow printing"
Create a Rollup View in Airtable
Kate Ruff
83 steps
5 minutes
Airtable
1
Navigate to [https://airtable.com/appFRP7wWJIfRAYzE/pag2WIfimWO5HzZ0A/edit](https://airtable.com/appFRP7wWJIfRAYzE/pag2WIfimWO5HzZ0A/edit)
2
Click this button.
3
Click "Pivot table"
4
Click "None"
5
Click this icon.
6
Click this icon.
7
Click "Theme"
8
Click this icon.
9
Click "is exactly..."
10
Click here.
11
Click "Food Security"
12
Click this icon.
13
Click this icon.
14
Click "Headline Indicators"
15
Click this icon.
16
Click "is not empty"
17
Click this icon.
18
Click the "Title" field.
19
Type "Food Security"
20
Click "value"
21
Click "Headline Indicators"
22
Click "startedAtTime"
23
Click "endedAtTime"
24
Click "None"
25
Click "Year"
26
Click "Field"
27
Click "Sum"
28
Click "Sum"
29
Click "value"
30
Click "value"
31
Click the "Show label" field.
32
Click the "Show totals" field.
33
Click the "Show totals" field.
34
Click the "Show totals" field.
35
Click "Food Security"
36
Click "2022"
37
Click "2023"
38
Click "Food Security"
39
Click "Food Security"
40
Click "Food Security"
41
Click "2024"
42
Double-click "Food Security"
43
Click "2025"
44
Click "Food Security"
45
Click "Food Security"
46
Click "Headline Indicators2022202320242025SumTotal dollar value of food cost savings for community members40,055.140,055.1Total individuals gaining the..."
47
Click "Food Security"
48
Click "Food Security"
49
Click "Sum"
50
Click this button.
51
Click "Pivot table"
52
Click "None"
53
Click "Add condition"
54
Click this icon.
55
Click "Theme"
56
Click this icon.
57
Click "is exactly..."
58
Click this icon.
59
Click "Economic Vitality"
60
Click "Add condition"
61
Click this icon.
62
Click "Headline Indicators"
63
Click this icon.
64
Click "is not empty"
65
Click the "Title" field.
66
Click the "Title" field.
67
Type "Economic Vitality"
68
Click "value"
69
Click "Headline Indicators"
70
Click "startedAtTime"
71
Click "endedAtTime"
72
Click "None"
73
Click "Year"
74
Click the "Show label" field.
75
Click the "Show totals" field.
76
Click the "Show totals" field.
77
Click the "Show totals" field.
78
Click "Field"
79
Click "value"
80
Click "value"
81
Click "Sum"
82
Click this checkbox.
83
Click "Allow printing"
