{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Start","Source data","PivotTable structure","Sample PivotTable"],"not_rendered":{"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this workbook to experiment with PivotTable reports."]
[null,"Create a sample PivotTable report using sample data from Source data worksheet and report template in PivotTable structure worksheet. "]
[null,"The sample list is created in Sample PivotTable worksheet and it can be sorted by any category or item. "]
[null,"You can also use slicers to filter data. To add slicer to a PivotTable, select INSERT SLICER in the FILTER group on ANALYSE ribbon under PIVOTTABLE TOOLS."]
[null,"PivotTable reports are one of the best Excel tools for extracting significance from a large, detailed data set. The data is organised in list format, similar to how a query returns database records: each column contains similar data, the columns have headings in the first row and the list is not interrupted by any blank rows or columns."]
[null,"Note: "]
[null,"Additional instructions have been provided in cells A1, A2 and A4 in both the SOURCE DATA and PIVOTTABLE STRUCTURE worksheets and in cells A1, A2, A4 and A12 of the SAMPLE PIVOT TABLE worksheet. This text has been intentionally hidden. To remove text, select column A or cell A1, then select DELETE. To unhide text, select column A or cell A1, then change font colour."]
[null,"To learn more about table, 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, then select ALT TEXT tab."]

{"sheet":"Source data","index":1,"n_rows":9,"n_cols":7,"rows_kept":9}
["Use sample data from Source Data table starting in cell B4 in this worksheet to create a sample PivotTable report. This sample data is the quarterly sum of sales with product and customer details. It also contains a helper-column with a formula to return a date. This column can be used in Timeline tools in PivotTable Report to filter data."]
["Worksheet title is in cell to the right. The next instruction is in cell A4.","Source data"]
[]
["Source data table is starting in cell to the right.","Product","Customer","Year","Quarter","Amount","Timeline"]
[null,"Product 1","Customer 1",{"$f":"YEAR(TODAY())+1","v":2020},2,{"v":702,"d":"£702.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2020-08-01"}]
[null,"Product 2","Customer 2",{"$f":"YEAR(TODAY())+1","v":2020},1,{"v":312,"d":"£312.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2020-04-01"}]
[null,"Product 3","Customer 3",2020,4,{"v":1170,"d":"£1,170.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2021-04-01"}]
[null,"Product 4","Customer 4",2020,1,{"v":1170,"d":"£1,170.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2020-04-01"}]
[null,"Product 5","Customer 5",2020,1,{"v":3730.3500000000004,"d":"£3,730.35"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2020-04-01"}]

{"sheet":"PivotTable structure","index":2,"n_rows":4,"n_cols":2,"rows_kept":4}
["Use PivotTable report template starting in cell B4 in this worksheet to show data in different ways."]
["Title of this worksheet is in cell to the right.","PivotTable report"]
[]
["PivotTable report template is in cell to the right."]

{"sheet":"Sample PivotTable","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[3,9,10,13],[11,9,18,13]]}
["Sample PivotTable report, created using sample data from Source data worksheet, is in this worksheet. Helpful instructions on how to use this worksheet are in the cells in this column."]
["Title of this worksheet is in this cell. The next instruction is in cell A4.","Sample PivotTable report"]
[]
["Timeline slicer to filter data for years is in cell J4. You can use slide control to filter data for quarter, months or days. Next instruction is in cell A12."," Amount",null,"Year","Quarter"]
[{"$nulls":3},2020,null,null,"2020 Total"]
[null,"Customer","Product",1,2,4]
[null,"Customer 1",null,null,{"v":702,"d":"£702.00"},null,{"v":702,"d":"£702.00"}]
[null,null,"Product 1",null,{"v":702,"d":"£702.00"},null,{"v":702,"d":"£702.00"}]
[null,"Customer 2",null,{"v":312,"d":"£312.00"},null,null,{"v":312,"d":"£312.00"}]
[null,null,"Product 2",{"v":312,"d":"£312.00"},null,null,{"v":312,"d":"£312.00"}]
[null,"Customer 3",{"$nulls":3},{"v":1170,"d":"£1,170.00"},{"v":1170,"d":"£1,170.00"}]
["Timeline slicer to filter data for quarters is in cell J12. You can use slide control to filter data for years, months or days. If you want to drill down data, select data cell in the PivotTable, press SHIFT, then F10 and then select SHOW DETAILS to get the details in separate worksheet.",null,"Product 3",null,null,{"v":1170,"d":"£1,170.00"},{"v":1170,"d":"£1,170.00"}]
[null,"Customer 4",null,{"v":1170,"d":"£1,170.00"},null,null,{"v":1170,"d":"£1,170.00"}]
[null,null,"Product 4",{"v":1170,"d":"£1,170.00"},null,null,{"v":1170,"d":"£1,170.00"}]
[null,"Customer 5",null,{"v":3730.3500000000004,"d":"£3,730.35"},null,null,{"v":3730.3500000000004,"d":"£3,730.35"}]
[null,null,"Product 5",{"v":3730.3500000000004,"d":"£3,730.35"},null,null,{"v":3730.3500000000004,"d":"£3,730.35"}]