{"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, and 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":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."]
[null,"Source Data"]
[]
[null,"Product","Customer","Year","Quarter","Amount","Timeline"]
[null,"Product 1","Customer 1",{"$f":"YEAR(TODAY())+1","v":2023},2,{"v":702,"d":"£702.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2023-08-01"}]
[null,"Product 2","Customer 2",{"$f":"YEAR(TODAY())+1","v":2023},1,{"v":312,"d":"£312.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2023-04-01"}]
[null,"Product 3","Customer 3",2023,4,{"v":1170,"d":"£1,170.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2024-04-01"}]
[null,"Product 4","Customer 4",2023,1,{"v":1170,"d":"£1,170.00"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2023-04-01"}]
[null,"Product 5","Customer 5",2023,1,{"v":3730.3500000000004,"d":"£3,730.35"},{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":"2023-04-01"}]

{"sheet":"PivotTable Structure","index":2,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"PivotTable Report"]

{"sheet":"Sample PivotTable","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[3,9,10,13],[11,9,18,13]]}
[]
[null,"Sample PivotTable Report"]
[]
[null," Amount",null,"Year","Quarter"]
[{"$nulls":3},2023,null,null,"2023 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"}]
[null,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"}]