{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Sheet1","Data","MethodTwo","Wrap Up"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":33,"comments":0,"pivot_tables":2},"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2080]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Silentpilot / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":2,"n_rows":81,"n_cols":5,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Product","Revenue"]
["Carbon Steel Pipe",8733.7999999999993,null,"Product2","Sum of Revenue"]
["Carbon Steel Flanges",7944.97,null,"Carbon Steel",239190.46000000002]
["Stainless Steel Pipe",3155.71,null,"Stainless Steel",213104.08000000002]
["Stainless Steel Flanges",9255.9699999999993,null,"Grand Total",452294.54000000004]
["Carbon Steel Pipe",2549.44]
["Carbon Steel Flanges",9412.5400000000009]
["Stainless Steel Pipe",2977.24]
["Stainless Steel Flanges",4309.8999999999996]
["Carbon Steel Pipe",3931.17]
["Carbon Steel Flanges",6771.94]
["Stainless Steel Pipe",8725.7000000000007]
["Stainless Steel Flanges",1355.97]
["Carbon Steel Pipe",6464.4]
["Carbon Steel Flanges",2017.64]
["Stainless Steel Pipe",1191.8900000000001]
["Stainless Steel Flanges",4256.6000000000004]
["Carbon Steel Pipe",8822.14]
["Carbon Steel Flanges",3351.61]
["Stainless Steel Pipe",1854.34]
["Stainless Steel Flanges",9518.69]
["Carbon Steel Pipe",9494.89]
["Carbon Steel Flanges",9558.9699999999993]
["Stainless Steel Pipe",2123.83]
["Stainless Steel Flanges",7646.83]
["Carbon Steel Pipe",8444.7999999999993]
["Carbon Steel Flanges",8466.23]
["Stainless Steel Pipe",1262.51]
["Stainless Steel Flanges",6810.84]
["Carbon Steel Pipe",9114.09]
["Carbon Steel Flanges",2349.9299999999998]
["Stainless Steel Pipe",5153.57]
["Stainless Steel Flanges",9682.57]
["Carbon Steel Pipe",2838.32]
["Carbon Steel Flanges",8059.71]
["Stainless Steel Pipe",3821.97]
["Stainless Steel Flanges",6985.74]
["Carbon Steel Pipe",7933.89]
["Carbon Steel Flanges",1643.23]
["Stainless Steel Pipe",5017]
["Stainless Steel Flanges",4805.97]
["Carbon Steel Pipe",2945.53]
["Carbon Steel Flanges",8566.7099999999991]
["Stainless Steel Pipe",9959.9599999999991]
["Stainless Steel Flanges",3334.79]
["Carbon Steel Pipe",2299.67]
["Carbon Steel Flanges",8167.73]
["Stainless Steel Pipe",7511.85]
["Stainless Steel Flanges",6682.72]
["Carbon Steel Pipe",8299.2999999999993]
["Carbon Steel Flanges",1090.47]
["Stainless Steel Pipe",8192.36]
["Stainless Steel Flanges",4068.95]
["Carbon Steel Pipe",4691.2700000000004]
["Carbon Steel Flanges",5020.2]
["Stainless Steel Pipe",2473.38]
["Stainless Steel Flanges",4132.5200000000004]
["Carbon Steel Pipe",5390.59]
["Carbon Steel Flanges",2044.02]
["Stainless Steel Pipe",9781.49]
["Stainless Steel Flanges",3972.92]
["Carbon Steel Pipe",7040.2]
["Carbon Steel Flanges",8448.17]
["Stainless Steel Pipe",2956.19]
["Stainless Steel Flanges",9417.65]
["Carbon Steel Pipe",7238.98]
["Carbon Steel Flanges",2094.5300000000002]
["Stainless Steel Pipe",4799.07]
["Stainless Steel Flanges",6232.81]
["Carbon Steel Pipe",6470.55]
["Carbon Steel Flanges",9362.31]
["Stainless Steel Pipe",6260.06]
["Stainless Steel Flanges",1724.98]
["Carbon Steel Pipe",2395.56]
["Carbon Steel Flanges",8026.97]
["Stainless Steel Pipe",5368.36]
["Stainless Steel Flanges",7998.42]
["Carbon Steel Pipe",3153]
["Carbon Steel Flanges",8540.99]
["Stainless Steel Pipe",5877.27]
["Stainless Steel Flanges",2445.4899999999998]

{"sheet":"MethodTwo","index":3,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Product","Revenue",null,null,null,"Product","Category"]
["Carbon Steel Pipe",8733.7999999999993,null,null,null,"Carbon Steel Pipe","Carbon"]
["Carbon Steel Flanges",7944.97,null,null,null,"Carbon Steel Flanges","Carbon",null,"Category","Sum of Revenue"]
["Stainless Steel Pipe",3155.71,null,null,null,"Stainless Steel Pipe","Stainless",null,"Carbon",239190.46]
["Stainless Steel Flanges",9255.9699999999993,null,null,null,"Stainless Steel Flanges","Stainless",null,"Stainless",213104.08]
["Carbon Steel Pipe",2549.44,null,null,null,null,null,null,"Grand Total",452294.54]
["Carbon Steel Flanges",9412.5400000000009]
["Stainless Steel Pipe",2977.24]
["Stainless Steel Flanges",4309.8999999999996]
["Carbon Steel Pipe",3931.17]
["Carbon Steel Flanges",6771.94]
["Stainless Steel Pipe",8725.7000000000007]
["Stainless Steel Flanges",1355.97]
["Carbon Steel Pipe",6464.4]
["Carbon Steel Flanges",2017.64]
["Stainless Steel Pipe",1191.8900000000001]
["Stainless Steel Flanges",4256.6000000000004]
["Carbon Steel Pipe",8822.14]
["Carbon Steel Flanges",3351.61]
["Stainless Steel Pipe",1854.34]
["Stainless Steel Flanges",9518.69]
["Carbon Steel Pipe",9494.89]
["Carbon Steel Flanges",9558.9699999999993]
["Stainless Steel Pipe",2123.83]
["Stainless Steel Flanges",7646.83]
["Carbon Steel Pipe",8444.7999999999993]
["Carbon Steel Flanges",8466.23]
["Stainless Steel Pipe",1262.51]
["Stainless Steel Flanges",6810.84]
["Carbon Steel Pipe",9114.09]
["Carbon Steel Flanges",2349.9299999999998]
["Stainless Steel Pipe",5153.57]
["Stainless Steel Flanges",9682.57]
["Carbon Steel Pipe",2838.32]
["Carbon Steel Flanges",8059.71]
["Stainless Steel Pipe",3821.97]
["Stainless Steel Flanges",6985.74]
["Carbon Steel Pipe",7933.89]
["Carbon Steel Flanges",1643.23]
["Stainless Steel Pipe",5017]
["Stainless Steel Flanges",4805.97]
["Carbon Steel Pipe",2945.53]
["Carbon Steel Flanges",8566.7099999999991]
["Stainless Steel Pipe",9959.9599999999991]
["Stainless Steel Flanges",3334.79]
["Carbon Steel Pipe",2299.67]
["Carbon Steel Flanges",8167.73]
["Stainless Steel Pipe",7511.85]
["Stainless Steel Flanges",6682.72]
["Carbon Steel Pipe",8299.2999999999993]
["Carbon Steel Flanges",1090.47]
["Stainless Steel Pipe",8192.36]
["Stainless Steel Flanges",4068.95]
["Carbon Steel Pipe",4691.2700000000004]
["Carbon Steel Flanges",5020.2]
["Stainless Steel Pipe",2473.38]
["Stainless Steel Flanges",4132.5200000000004]
["Carbon Steel Pipe",5390.59]
["Carbon Steel Flanges",2044.02]
["Stainless Steel Pipe",9781.49]
["Stainless Steel Flanges",3972.92]
["Carbon Steel Pipe",7040.2]
["Carbon Steel Flanges",8448.17]
["Stainless Steel Pipe",2956.19]
["Stainless Steel Flanges",9417.65]
["Carbon Steel Pipe",7238.98]
["Carbon Steel Flanges",2094.5300000000002]
["Stainless Steel Pipe",4799.07]
["Stainless Steel Flanges",6232.81]
["Carbon Steel Pipe",6470.55]
["Carbon Steel Flanges",9362.31]
["Stainless Steel Pipe",6260.06]
["Stainless Steel Flanges",1724.98]
["Carbon Steel Pipe",2395.56]
["Carbon Steel Flanges",8026.97]
["Stainless Steel Pipe",5368.36]
["Stainless Steel Flanges",7998.42]
["Carbon Steel Pipe",3153]
["Carbon Steel Flanges",8540.99]
["Stainless Steel Pipe",5877.27]
["Stainless Steel Flanges",2445.4899999999998]

{"sheet":"Wrap Up","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Lourdes wants to group text in a pivot table"]
[null,"Method 1: Create the pivot table with Product in the Rows area."]
[null,"Select all of the items for the first group. Use Analyze, Group Selection."]
[null,"Select all of the items for the second group. Use Analyze, Group Selection."]
[null,"Type new category names instead of Group1 and Group2."]
[null,"Optionally, remove the original Product from the pivot table"]
[null,"Method 2: Build a lookup table"]
[null,"Make both tables be Ctrl+T tables (Don't forget to check Use Headers)"]
[null,"Build a pivot table from both tables using the All link at the top of the field list"]
[null,"Define a relationship."]