Tabela przestawna: suma według produktu

Tabele i wykresy przestawne - Arkusz kalkulacyjny w liceum i technikum (sheet)

Arkusz **Dane** to sprzedaż na kiermaszu: każdy wiersz to jedna transakcja (klasa, produkt, liczba sztuk, kwota w zł). **Tabela przestawna** w arkuszu **Przestawna** grupuje te wiersze według produktu i sumuje kwotę, bez ani jednej formuły. Wstawia się ją przyciskiem **Tabela przestawna** na pasku: wybierasz zakres danych z nagłówkiem, pole do **wierszy** (Produkt) i **wartość** (Suma z Kwota). Wynik to zwykłe komórki tylko do odczytu: przelicza się sam, gdy zmienisz dane. Klucze są ułożone alfabetycznie, liczby rosnąco, a ostatni wiersz to **Suma końcowa**. Obok jest **wykres przestawny**: wykres z wyniku tabeli, który rośnie razem z nią. Kliknij komórkę tabeli i **Zmień tabelę**, żeby obejrzeć jej ustawienia.

{"sheets":[{"name":"Dane","cells":{"A1":"Klasa","B1":"Produkt","C1":"Sztuk","D1":"Kwota","A2":"1a","B2":"ciasto","C2":"12","D2":"48","A3":"1b","B3":"lemoniada","C3":"20","D3":"60","A4":"2a","B4":"kanapki","C4":"15","D4":"45","A5":"1a","B5":"lemoniada","C5":"18","D5":"54","A6":"1b","B6":"ciasto","C6":"9","D6":"36","A7":"2a","B7":"muffinki","C7":"14","D7":"56","A8":"1a","B8":"kanapki","C8":"10","D8":"30","A9":"2a","B9":"lemoniada","C9":"22","D9":"66","A10":"1b","B10":"muffinki","C10":"11","D10":"44","A11":"2a","B11":"ciasto","C11":"7","D11":"28","A12":"1a","B12":"muffinki","C12":"16","D12":"64","A13":"1b","B13":"kanapki","C13":"13","D13":"39","A14":"2a","B14":"kanapki","C14":"8","D14":"24","A15":"1a","B15":"lemoniada","C15":"6","D15":"18","A16":"1b","B16":"ciasto","C16":"5","D16":"20","A17":"2a","B17":"muffinki","C17":"9","D17":"36","A18":"1a","B18":"ciasto","C18":"4","D18":"16","A19":"1b","B19":"lemoniada","C19":"12","D19":"36"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"}},"cols":{"B":90,"G":120},"freeze":{"rows":1,"cols":0}},{"name":"Przestawna","cells":{"A1":"Produkt","B1":"Suma z Kwota","A2":"ciasto","B2":"148","A3":"kanapki","B3":"138","A4":"lemoniada","B4":"234","A5":"muffinki","B5":"200","A6":"Suma końcowa","B6":"720"},"formats":{"A1":{"bold":true},"B1":{"bold":true},"A6":{"bold":true},"B6":{"bold":true}},"cols":{"A":120,"B":110},"charts":[{"type":"column","range":"A1:B5","width":420,"height":260,"title":"Kwota według produktu","legend":false,"at":"D1"}],"pivots":[{"source":"A1:D19","at":"A1","values":[{"field":"D","agg":"sum"}],"sourceSheet":"Dane","rows":"B","chart":"D1","size":{"rows":6,"cols":2}}]}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.