{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Source Data","Sample PivotTable","Delete Pivot Table with Data","Delete Pivot Table without Data","Applying VBA code","How to Move Pivot Table","Delete a Pivot Table Field"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":6},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Source Data","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
["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,"Sample Dataset"]
[]
[null,"Product","Customer","Year","Quarter","Amount","Timeline"]
[null,"Product 1","Customer 1",{"$f":"YEAR(TODAY())+1","v":2023},2,702,{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":45139}]
[null,"Product 2","Customer 2",{"$f":"YEAR(TODAY())+1","v":2023},1,312,{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":45017}]
[null,"Product 3","Customer 3",2023,4,1170,{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":45383}]
[null,"Product 4","Customer 4",2023,1,1170,{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":45017}]
[null,"Product 5","Customer 5",2023,1,3730.3500000000004,{"$f":"DATE(SourceData[[#This Row],[Year]],SourceData[[#This Row],[Quarter]]*4,1)","v":45017}]

{"sheet":"Sample PivotTable","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,9,10,13],[11,9,18,13],[1,1,1,2]]}
[]
[null,"Sample Pivot Table Report"]
[]
[null,"Customer","Sum of Amount"]
[null,"Customer 1",702]
[null,"Customer 2",312]
[null,"Customer 3",1170]
[null,"Customer 4",1170]
[null,"Customer 5",3730.3500000000004]

{"sheet":"Delete Pivot Table with Data","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,9,10,13],[11,9,18,13],[1,6,1,7]]}
[]
[null,"Delete Pivot Table with Table Data",null,null,null,null,"Practice Yourself Here"]
[]
[null,null,null,null,null,null,"Customer","Sum of Amount"]
[null,null,null,null,null,null,"Customer 1",702]
[null,null,null,null,null,null,"Customer 2",312]
[null,null,null,null,null,null,"Customer 3",1170]
[null,null,null,null,null,null,"Customer 4",1170]
[null,null,null,null,null,null,"Customer 5",3730.3500000000004]

{"sheet":"Delete Pivot Table without Data","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Delete Pivot Table without Table Data",null,null,null,null,null,null,"Practice Yourself Here"]
[]
[null,null,null,null,"Customer","Sum of Amount",null,null,"Customer","Sum of Amount"]
[null,null,null,null,"Customer 1",702,null,null,"Customer 1",702]
[null,null,null,null,"Customer 2",312,null,null,"Customer 2",312]
[null,null,null,null,"Customer 3",1170,null,null,"Customer 3",1170]
[null,null,null,null,"Customer 4",1170,null,null,"Customer 4",1170]
[null,null,null,null,"Customer 5",3730.3500000000004,null,null,"Customer 5",3730.3500000000004]

{"sheet":"Applying VBA code","index":4,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[11,9,18,13],[1,6,1,7]]}
[]
[null,"Applying VBA code",null,null,null,null,"Practice Yourself Here"]
[]
[null,null,null,null,null,null,"Customer","Sum of Amount"]
[null,null,null,null,null,null,"Customer 1",702]
[null,null,null,null,null,null,"Customer 2",312]
[null,null,null,null,null,null,"Customer 3",1170]
[null,null,null,null,null,null,"Customer 4",1170]
[null,null,null,null,null,null,"Customer 5",3730.3500000000004]

{"sheet":"How to Move Pivot Table","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,9,10,13],[11,9,18,13]]}
[]
[null,"How to Move Pivot Table"]
[]
[null,null,null,null,null,"Customer","Sum of Amount"]
[null,null,null,null,null,"Customer 1",702]
[null,null,null,null,null,"Customer 2",312]
[null,null,null,null,null,"Customer 3",1170]
[null,null,null,null,null,"Customer 4",1170]
[null,null,null,null,null,"Customer 5",3730.3500000000004]

{"sheet":"Delete a Pivot Table Field","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,9,10,13],[11,9,18,13]]}
[]
[null,"Delete a Pivot Table Field"]
[]
[null,"Customer"]
[null,"Customer 1"]
[null,"Customer 2"]
[null,"Customer 3"]
[null,"Customer 4"]
[null,"Customer 5"]