{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Sheet1","Sheet2","Sheet3","Sheet4","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Information of Customer Care Unit"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,"10-001","2023-01-05","John Smith","Technical","High","Open"]
[null,"10-002","2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,"10-003","2023-01-10","David Brown","Technical","Low","Closed"]
[null,"10-004","2023-01-12","Lisa Davis","General","High","Open"]
[null,"10-005","2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,"10-006","2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,"10-007","2023-01-20","Robert Miller","Technical","High","Open"]
[null,"10-008","2023-01-23","Emily Wilson","General","Medium","Open"]
[null,"10-009","2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,"10-010","2023-01-28","Samantha Chen","General","High","Open"]
[null,"10-011","2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,"10-012","2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,"10-013","2023-02-08","Christopher","General","High","Open"]
[null,"10-014","2023-02-10","Amanda White","Technical","Medium","Open"]
[null,"10-015","2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,"10-016","2023-02-18","Olivia Turner","Technical","High","Open"]
[null,"10-017","2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,"10-018","2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,"10-019","2023-02-28","Ethan Scott","General","High","Open"]
[null,"10-020","2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,"Priority","(All)",null,"Filter Keyword"]
[]
[null,"Count of Status","Category"]
[null,"Month","Billing","General","Technical","Grand Total"]
[null,"Jan",2,3,5,10]
[null,"Feb",2,3,4,9]
[null,"Mar",1,null,null,1]
[null,"Grand Total",5,6,9,20]

{"sheet":"Sheet1","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Creating a Filter in PivotTable Based on Cell Value"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,"10-001","2023-01-05","John Smith","Technical","High","Open"]
[null,"10-002","2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,"10-003","2023-01-10","David Brown","Technical","Low","Closed"]
[null,"10-004","2023-01-12","Lisa Davis","General","High","Open"]
[null,"10-005","2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,"10-006","2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,"10-007","2023-01-20","Robert Miller","Technical","High","Open"]
[null,"10-008","2023-01-23","Emily Wilson","General","Medium","Open"]
[null,"10-009","2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,"10-010","2023-01-28","Samantha Chen","General","High","Open"]
[null,"10-011","2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,"10-012","2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,"10-013","2023-02-08","Christopher","General","High","Open"]
[null,"10-014","2023-02-10","Amanda White","Technical","Medium","Open"]
[null,"10-015","2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,"10-016","2023-02-18","Olivia Turner","Technical","High","Open"]
[null,"10-017","2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,"10-018","2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,"10-019","2023-02-28","Ethan Scott","General","High","Open"]
[null,"10-020","2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,"Priority","High",null,"Filter Keyword","High"]
[]
[null,"Count of Status","Category"]
[null,"Month","General","Technical","Grand Total"]
[null,"Jan",2,2,4]
[null,"Feb",2,1,3]
[null,"Grand Total",4,3,7]

{"sheet":"Sheet2","index":2,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Creating  a Filter in PivotTable Using Multiple Cell Values"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,"10-001","2023-01-05","John Smith","Technical","High","Open"]
[null,"10-002","2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,"10-003","2023-01-10","David Brown","Technical","Low","Closed"]
[null,"10-004","2023-01-12","Lisa Davis","General","High","Open"]
[null,"10-005","2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,"10-006","2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,"10-007","2023-01-20","Robert Miller","Technical","High","Open"]
[null,"10-008","2023-01-23","Emily Wilson","General","Medium","Open"]
[null,"10-009","2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,"10-010","2023-01-28","Samantha Chen","General","High","Open"]
[null,"10-011","2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,"10-012","2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,"10-013","2023-02-08","Christopher","General","High","Open"]
[null,"10-014","2023-02-10","Amanda White","Technical","Medium","Open"]
[null,"10-015","2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,"10-016","2023-02-18","Olivia Turner","Technical","High","Open"]
[null,"10-017","2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,"10-018","2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,"10-019","2023-02-28","Ethan Scott","General","High","Open"]
[null,"10-020","2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,"Priority","(Multiple Items)",null,"Filter Keywords","High","Low"]
[]
[null,"Count of Status","Category"]
[null,"Month","Billing","General","Technical","Grand Total"]
[null,"Jan",1,2,4,7]
[null,"Feb",1,2,3,6]
[null,"Grand Total",2,4,7,13]

{"sheet":"Sheet3","index":3,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Creating a Row Filter in PivotTable Based on Cell Value"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,"10-001","2023-01-05","John Smith","Technical","High","Open"]
[null,"10-002","2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,"10-003","2023-01-10","David Brown","Technical","Low","Closed"]
[null,"10-004","2023-01-12","Lisa Davis","General","High","Open"]
[null,"10-005","2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,"10-006","2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,"10-007","2023-01-20","Robert Miller","Technical","High","Open"]
[null,"10-008","2023-01-23","Emily Wilson","General","Medium","Open"]
[null,"10-009","2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,"10-010","2023-01-28","Samantha Chen","General","High","Open"]
[null,"10-011","2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,"10-012","2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,"10-013","2023-02-08","Christopher","General","High","Open"]
[null,"10-014","2023-02-10","Amanda White","Technical","Medium","Open"]
[null,"10-015","2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,"10-016","2023-02-18","Olivia Turner","Technical","High","Open"]
[null,"10-017","2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,"10-018","2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,"10-019","2023-02-28","Ethan Scott","General","High","Open"]
[null,"10-020","2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,null,null,null,null,"Filter Keywords","Technical"]
[]
[null,"Count of Status","Priority"]
[null,"Category","High","Low","Medium","Grand Total"]
[null,"Technical",3,4,2,9]
[null,"Grand Total",3,4,2,9]

{"sheet":"Sheet4","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Clearing All Filters in Pivot Table"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,"10-001","2023-01-05","John Smith","Technical","High","Open"]
[null,"10-002","2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,"10-003","2023-01-10","David Brown","Technical","Low","Closed"]
[null,"10-004","2023-01-12","Lisa Davis","General","High","Open"]
[null,"10-005","2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,"10-006","2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,"10-007","2023-01-20","Robert Miller","Technical","High","Open"]
[null,"10-008","2023-01-23","Emily Wilson","General","Medium","Open"]
[null,"10-009","2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,"10-010","2023-01-28","Samantha Chen","General","High","Open"]
[null,"10-011","2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,"10-012","2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,"10-013","2023-02-08","Christopher","General","High","Open"]
[null,"10-014","2023-02-10","Amanda White","Technical","Medium","Open"]
[null,"10-015","2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,"10-016","2023-02-18","Olivia Turner","Technical","High","Open"]
[null,"10-017","2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,"10-018","2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,"10-019","2023-02-28","Ethan Scott","General","High","Open"]
[null,"10-020","2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,"Priority","(All)"]
[]
[null,"Count of Status","Category"]
[null,"Month","Billing","General","Technical","Grand Total"]
[null,"Jan",2,3,5,10]
[null,"Feb",2,3,4,9]
[null,"Mar",1,null,null,1]
[null,"Grand Total",5,6,9,20]

{"sheet":"Practice Sheet","index":5,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of VBA to Filter Pivot Table Based on Cell Value"]
[]
[null,"Ticket ID","Date","Customer Name","Category","Priority","Status"]
[null,"10-001","2023-01-05","John Smith","Technical","High","Open"]
[null,"10-002","2023-01-07","Sarah Johnson","Billing","Medium","Open"]
[null,"10-003","2023-01-10","David Brown","Technical","Low","Closed"]
[null,"10-004","2023-01-12","Lisa Davis","General","High","Open"]
[null,"10-005","2023-01-15","Michael Lee","Technical","Medium","Open"]
[null,"10-006","2023-01-18","Jessica Wang","Billing","Low","Closed"]
[null,"10-007","2023-01-20","Robert Miller","Technical","High","Open"]
[null,"10-008","2023-01-23","Emily Wilson","General","Medium","Open"]
[null,"10-009","2023-01-25","Brian Thompson","Technical","Low","Closed"]
[null,"10-010","2023-01-28","Samantha Chen","General","High","Open"]
[null,"10-011","2023-02-02","Daniel Clark","Billing","Medium","Open"]
[null,"10-012","2023-02-05","Jennifer Wong","Technical","Low","Closed"]
[null,"10-013","2023-02-08","Christopher","General","High","Open"]
[null,"10-014","2023-02-10","Amanda White","Technical","Medium","Open"]
[null,"10-015","2023-02-14","Andrew Lewis","Billing","Low","Closed"]
[null,"10-016","2023-02-18","Olivia Turner","Technical","High","Open"]
[null,"10-017","2023-02-20","Benjamin Hill","General","Medium","Open"]
[null,"10-018","2023-02-25","Lily Parker","Technical","Low","Closed"]
[null,"10-019","2023-02-28","Ethan Scott","General","High","Open"]
[null,"10-020","2023-03-02","Victoria Chen","Billing","Medium","Open"]
[]
[null,"Priority","High",null,"Filter Keyword","High"]
[]
[null,"Count of Status","Category"]
[null,"Month","General","Technical","Grand Total"]
[null,"Jan",2,2,4]
[null,"Feb",2,1,3]
[null,"Grand Total",4,3,7]