{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Single Criteria","Multiple Filter","Filter Based on a Cell Value","Using Slicer","Dynamic Filter","Clear Filter in Pivot Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Pivot Table with Filter Using VBA Macro"]
[]
[null,"Salesperson Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30]
[null,"Paul","South","Model Boat",3000,50]
[null,"Rachel","West","RC Car",4000,80]
[null,"Sarah","East","Model Boat",3500,60]
[null,"Tom","North","RC Car",4500,90]
[null,"Victor","South","Widget",2000,30]

{"sheet":"Single Criteria","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Pivot Table with Filter Using Single Criteria"]
[]
[null,"Salesperson\n Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30]
[null,"Paul","South","Model Boat",3000,50]
[null,"Rachel","West","RC Car",4000,80]
[null,"Sarah","East","Model Boat",3500,60]
[null,"Tom","North","RC Car",4500,90]
[null,"Victor","South","Widget",2000,30]
[]
[null,"Product","Widget"]
[]
[null,null,"Values"]
[null,"Row Labels","Total Sales","Total Quantity"]
[null,"North",2000,30]
[null,"South",2150,45]
[null,"West",100,10]
[null,"Grand Total",4250,85]

{"sheet":"Multiple Filter","index":2,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Pivot Table with Multiple Filters Using VBA Macro"]
[]
[null,"Salesperson\n Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30]
[null,"Paul","South","Model Boat",3000,50]
[null,"Rachel","West","RC Car",4000,80]
[null,"Sarah","East","Model Boat",3500,60]
[null,"Tom","North","RC Car",4500,90]
[null,"Victor","South","Widget",2000,30]
[]
[null,"Product","(Multiple Items)"]
[]
[null,null,"Values"]
[null,"Row Labels","Total Sales","Total Quantity"]
[null,"East",6250,120]
[null,"North",4750,115]
[null,"South",3050,55]
[null,"West",4000,80]
[null,"Grand Total",18050,370]

{"sheet":"Filter Based on a Cell Value","index":3,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,5],[20,4,20,5],[21,4,21,5]]}
[]
[null,"Pivot Table with Filter Based on a Cell Value"]
[]
[null,"Salesperson Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30]
[null,"Paul","South","Model Boat",3000,50]
[null,"Rachel","West","RC Car",4000,80]
[null,"Sarah","East","Model Boat",3500,60]
[null,"Tom","North","RC Car",4500,90]
[null,"Victor","South","Widget",2000,30]
[]
[null,"Product","RC Car",null,"Filter Criteria"]
[null,null,null,null,"RC Car"]
[null,null,"Values"]
[null,"Row Labels","Total Sales","Total Quantity"]
[null,"North",4750,115]
[null,"West",4000,80]
[null,"Grand Total",8750,195]

{"sheet":"Using Slicer","index":4,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Pivot Table with Filter Using Slicer"]
[]
[null,"Salesperson\n Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30]
[null,"Paul","South","Model Boat",3000,50]
[null,"Rachel","West","RC Car",4000,80]
[null,"Sarah","East","Model Boat",3500,60]
[null,"Tom","North","RC Car",4500,90]
[null,"Victor","South","Widget",2000,30]
[]
[]
[null,"Row Labels","Sum of Sales","Sum of Quantity"]
[null,"East",6450,140]
[null,"North",6750,145]
[null,"South",5200,100]
[null,"West",4400,120]
[null,"Grand Total",22800,505]

{"sheet":"Dynamic Filter","index":5,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,5],[20,4,20,5],[21,4,21,5]]}
[]
[null,"Pivot Table with Dynamic Filter Using VBA Macro"]
[]
[null,"Salesperson\n Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15,null,null,null,null,null,null,null,null,null,null,"Product","RC Car"]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30,null,null,null,null,null,null,null,null,null,null,null,"Values"]
[null,"Paul","South","Model Boat",3000,50,null,null,null,null,null,null,null,null,null,null,"Row Labels","Total Sales","Total Quantity"]
[null,"Rachel","West","RC Car",4000,80,null,null,null,null,null,null,null,null,null,null,"North",4750,115]
[null,"Sarah","East","Model Boat",3500,60,null,null,null,null,null,null,null,null,null,null,"West",4000,80]
[null,"Tom","North","RC Car",4500,90,null,null,null,null,null,null,null,null,null,null,"Grand Total",8750,195]
[null,"Victor","South","Widget",2000,30]
[]
[null,null,null,null,"Filter Criteria"]
[null,null,null,null,"RC Car",null,null,null,null,null," "]

{"sheet":"Clear Filter in Pivot Table","index":6,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Clear Pivot Table with Filter Using VBA Macro"]
[]
[null,"Salesperson\n Name","Region","Product","Sales","Quantity"]
[null,"John","West","Widget",100,10]
[null,"Mary","East","Remote",200,20]
[null,"Tom","North","RC Car",150,15]
[null,"Lisa","South","Model Boat",50,5]
[null,"Peter","West","Remote",300,30]
[null,"Sarah","East","Model Boat",250,25]
[null,"Bob","North","RC Car",100,10]
[null,"Jennifer","South","Widget",150,15]
[null,"Nancy","East","Model Boat",2500,35]
[null,"Olivia","North","Widget",2000,30]
[null,"Paul","South","Model Boat",3000,50]
[null,"Rachel","West","RC Car",4000,80]
[null,"Sarah","East","Model Boat",3500,60]
[null,"Tom","North","RC Car",4500,90]
[null,"Victor","South","Widget",2000,30]
[]
[null,"Product","(Multiple Items)"]
[]
[null,"Row Labels","Sum of Sales","Sum of Quantity"]
[null,"East",6250,120]
[null,"North",2000,30]
[null,"South",5200,100]
[null,"West",100,10]
[null,"Grand Total",13550,260]