data
bulan pekan hari nilai batasan bulan ramadhan
ramadhan 1 ahad 5 minggu ke 1
ramadhan 2 senin 6 hari ahad
ramadhan 1 selasa 7
ramadhan 2 ahad 9 fungsi
ramadhan 2 selasa 3
syawal 1 ahad 8
syawal 1 senin 9
syawal 2 selasa 7
syawal 2 ahad 3
syawal 2 senin 7
Page 1
Pivot Table_data_3
bulan syawal
pekan 2
hari - multiple -
Data
Sum - nilai Count - nilai Average - nilaiMax - nilai Min - nilai
10 2 5 7 3
Page 2
Pivot Table_data_2
Data
bulan pekan hari Sum - nilai Count - nilai Average - nilaiMax - nilai
ramadhan 1 ahad 5 1 5 5
selasa 7 1 7 7
2 ahad 9 1 9 9
selasa 3 1 3 3
senin 6 1 6 6
syawal 1 ahad 8 1 8 8
senin 9 1 9 9
2 ahad 3 1 3 3
selasa 7 1 7 7
senin 7 1 7 7
Total Result 64 10 6.4 9
Page 3
Pivot Table_data_2
Min - nilai
5
7
9
3
6
8
9
3
7
7
3
Page 4
Pivot Table_data_1
bulan ramadhan
pekan 1
hari ahad
Data
Sum - nilai Count - nilai Average - nilaiMedian - nilai Max - nilai Min - nilai Product - nilai
5 1 5 5 5 5 5
Page 5
Pivot Table_data_1
Count - nilai StDev - nilai StDev - nilai Var - nilai Var - nilai
1 0 #VALUE! #VALUE! 0
Page 6