{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Start","Source data","By product","By product-customer","By product-customer filtered"],"not_rendered":{"pivot_tables":3},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":6,"n_cols":2,"rows_kept":6}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this workbook to track quarterly sales of each product."]
[null,"Enter details in Source data worksheet and refresh all PivotTables in other worksheets to update sales data."]
[null,"Note: "]
[null,"Additional instructions have been provided in cell A1 in each worksheet. This text has been intentionally hidden. To remove text, select cell A1, then select DELETE. To unhide text, select cell A1, then change font colour."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, then select ALTERNATIVE TEXT. For PivotTables, press SHIFT and then F10 within a table, select PIVOTTABLE OPTIONS, and then select ALT TEXT tab."]

{"sheet":"Source data","index":1,"n_rows":8,"n_cols":7,"rows_kept":8}
["Create a Sales report in this worksheet. Enter details in Source data table starting in cell B3"]
[]
[null,"Product","Customer","Qtr 1","Qtr 2","Qtr 3","Qtr 4"]
[null,"Product 1","Customer 1",0,{"v":702,"d":"£702.00"},0,0]
[null,"Product 2","Customer 2",{"v":312,"d":"£312.00"},0,0,0]
[null,"Product 3","Customer 3",0,0,0,{"v":1170,"d":"£1,170.00"}]
[null,"Product 4","Customer 4",{"v":1170,"d":"£1,170.00"},0,0,0]
[null,"Product 5","Customer 5",{"v":1123.2,"d":"£1,123.20"},0,0,{"v":2607.15,"d":"£2,607.15"}]

{"sheet":"By product","index":2,"n_rows":9,"n_cols":6,"rows_kept":9}
["Update By Product PivotTable starting in cell B2 in this worksheet. Select Refresh under Analyse tab to update the changes made in Source data."]
["Values label is in cell C2.",null,"Values"]
["Product PivotTable is starting in cell to the right.","Product","Sum of Qtr 1","Sum of Qtr 2","Sum of Qtr 3","Sum of Qtr 4"]
[null,"Product 1",0,{"v":702,"d":"£702.00"},0,0]
[null,"Product 2",{"v":312,"d":"£312.00"},0,0,0]
[null,"Product 3",0,0,0,{"v":1170,"d":"£1,170.00"}]
[null,"Product 4",{"v":1170,"d":"£1,170.00"},0,0,0]
[null,"Product 5",{"v":1123.2,"d":"£1,123.20"},0,0,{"v":2607.15,"d":"£2,607.15"}]
[null,"Grand Total",{"v":2605.2,"d":"£2,605.20"},{"v":702,"d":"£702.00"},0,{"v":3777.15,"d":"£3,777.15"}]

{"sheet":"By product-customer","index":3,"n_rows":14,"n_cols":6,"rows_kept":14}
["Update By Product and Customer PivotTable starting in cell B2 in this worksheet. Select Refresh under Analyse tab to update the changes made in Source data."]
["Values label is in cell C2.",null,"Values"]
["By Product and Customer PivotTable is starting in cell to the right.","Product","Sum of Qtr 1","Sum of Qtr 2","Sum of Qtr 3","Sum of Qtr 4"]
[null,"Product 1"]
[null,"Customer 1",0,{"v":702,"d":"£702.00"},0,0]
[null,"Product 2"]
[null,"Customer 2",{"v":312,"d":"£312.00"},0,0,0]
[null,"Product 3"]
[null,"Customer 3",0,0,0,{"v":1170,"d":"£1,170.00"}]
[null,"Product 4"]
[null,"Customer 4",{"v":1170,"d":"£1,170.00"},0,0,0]
[null,"Product 5"]
[null,"Customer 5",{"v":1123.2,"d":"£1,123.20"},0,0,{"v":2607.15,"d":"£2,607.15"}]
[null,"Grand Total",{"v":2605.2,"d":"£2,605.20"},{"v":702,"d":"£702.00"},0,{"v":3777.15,"d":"£3,777.15"}]

{"sheet":"By product-customer filtered","index":4,"n_rows":16,"n_cols":6,"rows_kept":16}
["Update PivotTable starting in cell B4 in this worksheet. Select Refresh under Analyse tab to update the changes made in Source data. Next instruction is in cell A3."]
[]
["Tip is in cell to the right.","This PivotTable is filtered by the Top 10 selling products in Qtr 1"]
["Values label is in cell C4.",null,"Values"]
["Top 10 Product and Customer PivotTable is starting in cell to the right.","Product","Sum of Qtr 1","Sum of Qtr 2","Sum of Qtr 3","Sum of Qtr 4"]
[null,"Product 1"]
[null,"Customer 1",0,{"v":702,"d":"£702.00"},0,0]
[null,"Product 2"]
[null,"Customer 2",{"v":312,"d":"£312.00"},0,0,0]
[null,"Product 3"]
[null,"Customer 3",0,0,0,{"v":1170,"d":"£1,170.00"}]
[null,"Product 4"]
[null,"Customer 4",{"v":1170,"d":"£1,170.00"},0,0,0]
[null,"Product 5"]
[null,"Customer 5",{"v":1123.2,"d":"£1,123.20"},0,0,{"v":2607.15,"d":"£2,607.15"}]
[null,"Grand Total",{"v":2605.2,"d":"£2,605.20"},{"v":702,"d":"£702.00"},0,{"v":3777.15,"d":"£3,777.15"}]