{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Таблицы","ИТОГО 2019-2020-2021"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Таблицы","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,14,0,22]]}
[]
["ТАБЛИЦА2019"]
["ИМЯ","Дата","Важное","Значение","Сумма1","Сумма2","Сумма3","Сумма 0"]
["Вася","2019-01-01",10000,40,10,10,30,5]
["Вася","2019-02-01",10001,60,10,20,30]
["Петя ","2019-05-02",10002,60,10,20,30]
["Степа","2019-06-02",10003,70,20,20,30,10]
[null,null,null,{"$f":"SUM(D4:D7)","v":230},{"$f":"SUM(E4:E7)","v":50},{"$f":"SUM(F4:F7)","v":70},{"$f":"SUM(G4:G7)","v":120},{"$f":"SUM(H4:H7)","v":15}]
[]
["ТАБЛИЦА2020"]
["ИМЯ","Дата","Важное","Значение","Сумма1","Сумма2","Сумма3","Сумма 0"]
["Вася","2020-01-01",10004,90,30,20,30,20]
["Петя ","2020-02-02",10005,100,20,30,50,5]
["Степа","2020-03-03",10006,30,10,10,10]
[null,null,null,{"$f":"SUM(D12:D14)","v":220},{"$f":"SUM(E12:E14)","v":60},{"$f":"SUM(F12:F14)","v":60},{"$f":"SUM(G12:G14)","v":90},{"$f":"SUM(H12:H14)","v":25}]
[]
["ТАБЛИЦА2021"]
["ИМЯ","Дата","Важное","Значение","Сумма1","Сумма2","Сумма3","Сумма 0"]
["Вася","2020-01-01",10007,90,30,20,30,20]
["Виктор ","2020-02-02",10008,100,20,30,50,5]
["Маша","2020-03-03",10009,30,10,10,10]
[null,null,null,{"$f":"SUM(D19:D21)","v":220},{"$f":"SUM(E19:E21)","v":60},{"$f":"SUM(F19:F21)","v":60},{"$f":"SUM(G19:G21)","v":90},{"$f":"SUM(H19:H21)","v":25}]

{"sheet":"ИТОГО 2019-2020-2021","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,2,29,8]]}
[]
[]
[null,null,"ИМЯ","Значение ","Сумма 0 "," Сумма1"," Сумма2"," Сумма3","Разница"]
[null,null,"Вася"]
[null,null,"2019-01-01"]
[null,null,"10000",40,5,10,10,30,10]
[null,null,"2019-02-01"]
[null,null,"10001",60,null,10,20,30,0]
[null,null,"2020-01-01"]
[null,null,"10004",90,20,30,20,30,-10]
[null,null,"10007",90,20,30,20,30,-10]
[null,null,"Виктор"]
[null,null,"2020-02-02"]
[null,null,"10008",100,5,20,30,50,0]
[null,null,"Маша"]
[null,null,"2020-03-03"]
[null,null,"10009",30,null,10,10,10,0]
[null,null,"Петя"]
[null,null,"2019-05-02"]
[null,null,"10002",60,null,10,20,30,0]
[null,null,"2020-02-02"]
[null,null,"10005",100,5,20,30,50,0]
[null,null,"Степа"]
[null,null,"2019-06-02"]
[null,null,"10003",70,10,20,20,30,0]
[null,null,"2020-03-03"]
[null,null,"10006",30,null,10,10,10,0]
[null,null,"Общий итог",670,65,170,190,300,-10]
[]
[null,null,"В Power Pivot созданы меры - итоговый столбец \"Разница\" выведен в сводную таблицу\nв одной из мер есть формула сложений столбцов \"Сумма1\", \"Сумма2\" и \"Сумма3\"\nНужно чтобы при сложении \"Сумма1\", \"Сумма2\" и \"Сумма3\", если в столбце \"Сумма0\" есть данные, тогда столбец \"Сумма1\" не учитывался, т.е складывались \"Сумма0\", \"Сумма2\" и \"Сумма3\"\n\n\n\n"]