{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["No.","Country","City"]
[1,"Saudi Arabia","Riyadh",null,"Row Labels","Count of City","USING A USER DEFINED FUNCTION"]
[2,"Saudi Arabia","Jeddah",null,"England",6]
[3,"Saudi Arabia","Abha",null,"Saudi Arabia",5,"England",{"$f":"distinctcount(Table1[City],Table1[Country],G4)","v":4}]
[4,"Saudi Arabia","Taif",null,"United States",6,"Saudi Arabia",{"$f":"distinctcount(Table1[City],Table1[Country],G5)","v":5}]
[5,"Saudi Arabia","Jubail",null,"Grand Total",17,"United States",{"$f":"distinctcount(Table1[City],Table1[Country],G6)","v":5}]
[6,"United States","New York"]
[7,"United States","New York",null,null,null,"USING POWER PIVOT"]
[8,"United States","Washington"]
[9,"United States","Miami",null,null,null,null,"Distinct Count of City"]
[10,"United States","California",null,null,null,"England",4]
[11,"United States","Chicago",null,null,null,"Saudi Arabia",5]
[12,"England","London",null,null,null,"United States",5]
[13,"England","Manchester",null,null,null,"Grand Total",14]
[14,"England","Liverpool"]
[15,"England","Liverpool"]
[16,"England","Glasgow"]
[17,"England","Glasgow"]