Update some values in pivot table snippets to reflect the new example.

Eric Koleda · Eric Koleda · commit ef634b06b0ac · 2019-01-03T09:28:45.000-05:00
diff --git a/sheets/snippets/spreadsheet_snippets.py b/sheets/snippets/spreadsheet_snippets.py
@@ -198,12 +198,12 @@ def pivot_tables(self, spreadsheet_id):
                                     'sheetId': source_sheet_id,
                                     'startRowIndex': 0,
                                     'startColumnIndex': 0,
-                                    'endRowIndex': 101,
-                                    'endColumnIndex': 8
+                                    'endRowIndex': 20,
+                                    'endColumnIndex': 7
                                 },
                                 'rows': [
                                     {
-                                        'sourceColumnOffset': 6,
+                                        'sourceColumnOffset': 1,
                                         'showTotals': True,
                                         'sortOrder': 'ASCENDING',
 
@@ -212,7 +212,7 @@ def pivot_tables(self, spreadsheet_id):
                                 ],
                                 'columns': [
                                     {
-                                        'sourceColumnOffset': 3,
+                                        'sourceColumnOffset': 4,
                                         'sortOrder': 'ASCENDING',
                                         'showTotals': True,
 
@@ -221,7 +221,7 @@ def pivot_tables(self, spreadsheet_id):
                                 'values': [
                                     {
                                         'summarizeFunction': 'COUNTA',
-                                        'sourceColumnOffset': 3
+                                        'sourceColumnOffset': 4
                                     }
                                 ],
                                 'valueLayout': 'HORIZONTAL'
