0% found this document useful (0 votes)
24 views10 pages

Pivot Table - Advance

The document provides sales data for various motorcycle brands across different areas in Indonesia for the months of January to March. It includes total sales figures and comparisons of stock sold, as well as details on vehicle models, their sales, and costs. Additionally, it outlines the total revenue and costs associated with each vehicle model over the period.

Uploaded by

khairunisa8255
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
24 views10 pages

Pivot Table - Advance

The document provides sales data for various motorcycle brands across different areas in Indonesia for the months of January to March. It includes total sales figures and comparisons of stock sold, as well as details on vehicle models, their sales, and costs. Additionally, it outlines the total revenue and costs associated with each vehicle model over the period.

Uploaded by

khairunisa8255
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

Bulan Motor Area Penjualan Motor

Jan Honda Jakarta 12,000,000


Feb Yamaha Jakarta 11,000,000 Sum of Penjualan
Feb Kawasaki Bandung 15,000,000 Area
Jan Honda Surabaya 13,000,000 Bandung
Mar Yamaha Surabaya 14,000,000 Jakarta
Mar Kawasaki Jakarta 17,000,000 Surabaya
Feb Honda Bandung 20,000,000 Total Result
Jan Yamaha Surabaya 13,000,000
Mar Kawasaki Surabaya 14,000,000
Feb Honda Surabaya 17,000,000
Mar Yamaha Jakarta 9,000,000
Mar Kawasaki Bandung 11,500,000
- all -

Bulan
Jan Feb Mar Total Result
35,000,000 11,500,000 46,500,000
12,000,000 11,000,000 26,000,000 49,000,000
26,000,000 17,000,000 28,000,000 71,000,000
38,000,000 63,000,000 65,500,000 166,500,000
Bulan All

Row Labels Sum of Penjualan Sum of Harga Modal


Avanza 9,061,000,000 6,123,000,000
Brio 9,528,000,000 6,066,000,000
CRV 9,606,000,000 6,183,000,000
Ertiga 10,059,000,000 6,574,000,000
Innova 10,998,000,000 7,681,000,000
Jazz 8,915,000,000 5,652,000,000
Juke 10,099,000,000 6,885,000,000
Land Cruiser 10,711,000,000 7,109,000,000
March 8,987,000,000 5,884,000,000
Pajero 10,495,000,000 6,723,000,000
Swift 9,844,000,000 6,483,000,000
Xpander 8,824,000,000 6,138,000,000
Grand Total 117,127,000,000 77,501,000,000
(empty)
Bulan Merek Tipe Area Stok Terjual Pajak Kadaluwarsa
Jan Toyota Avanza Jakarta 12 3/31/2024
Feb Toyota Innova Jakarta 12 2/28/2024
Mar Toyota Land Cruiser Jakarta 3 1/31/2024
Apr Honda Jazz Jakarta 6 3/31/2024
Apr Honda CRV Jakarta 7 2/28/2024
Jan Honda Brio Jakarta 10 1/31/2024
Feb Suzuki Ertiga Jakarta 10 3/31/2024
Mar Suzuki Swift Jakarta 5 2/28/2024
Jan Mitsubishi Xpander Jakarta 11 1/31/2024
Feb Mitsubishi Pajero Jakarta 5 3/31/2024
Mar Nissan March Jakarta 6 2/28/2024
Apr Nissan Juke Jakarta 6 1/31/2024
Apr Toyota Avanza Jakarta 11 3/31/2024
Jan Toyota Innova Jakarta 12 2/28/2024
Feb Toyota Land Cruiser Jakarta 2 1/31/2024
Mar Honda Jazz Jakarta 6 3/31/2024
Jan Honda CRV Jakarta 10 2/28/2024
Feb Honda Brio Jakarta 8 1/31/2024
Mar Suzuki Ertiga Jakarta 7 3/31/2024
Apr Suzuki Swift Jakarta 9 2/28/2024
Apr Mitsubishi Xpander Jakarta 12 1/31/2024
Jan Mitsubishi Pajero Jakarta 10 3/31/2024
Feb Nissan March Jakarta 9 2/28/2024
Mar Nissan Juke Jakarta 11 1/31/2024
Jan Toyota Avanza Jakarta 6 3/31/2024
Feb Toyota Innova Jakarta 6 2/28/2024
Mar Toyota Land Cruiser Jakarta 4 1/31/2024
Apr Honda Jazz Jakarta 5 3/31/2024
Apr Honda CRV Jakarta 7 2/28/2024
Jan Honda Brio Jakarta 6 1/31/2024
Feb Suzuki Ertiga Jakarta 7 3/31/2024
Mar Suzuki Swift Jakarta 6 2/28/2024
Jan Mitsubishi Xpander Jakarta 6 1/31/2024
Feb Mitsubishi Pajero Jakarta 5 3/31/2024
Mar Nissan March Jakarta 7 2/28/2024
Apr Nissan Juke Jakarta 6 1/31/2024
Apr Toyota Avanza Bandung 6 3/31/2024
Jan Toyota Innova Bandung 6 2/28/2024
Feb Toyota Land Cruiser Bandung 8 1/31/2024
Mar Honda Jazz Bandung 9 3/31/2024
Jan Honda CRV Bandung 11 2/28/2024
Feb Honda Brio Bandung 12 1/31/2024
Mar Suzuki Ertiga Bandung 6 3/31/2024
Apr Suzuki Swift Bandung 11 2/28/2024
Apr Mitsubishi Xpander Bandung 7 1/31/2024
Jan Mitsubishi Pajero Bandung 10 3/31/2024
Feb Nissan March Bandung 9 2/28/2024
Mar Nissan Juke Bandung 12 1/31/2024
Jan Toyota Avanza Bandung 5 3/31/2024
Feb Toyota Innova Bandung 7 2/28/2024
Mar Toyota Land Cruiser Bandung 11 1/31/2024
Apr Honda Jazz Bandung 10 3/31/2024
Apr Honda CRV Bandung 10 2/28/2024
Jan Honda Brio Bandung 6 1/31/2024
Feb Suzuki Ertiga Bandung 10 3/31/2024
Mar Suzuki Swift Bandung 6 2/28/2024
Jan Mitsubishi Xpander Bandung 6 1/31/2024
Feb Mitsubishi Pajero Bandung 12 3/31/2024
Mar Nissan March Bandung 10 2/28/2024
Apr Nissan Juke Bandung 7 1/31/2024
Apr Toyota Avanza Bandung 8 3/31/2024
Jan Toyota Innova Bandung 12 2/28/2024
Feb Toyota Land Cruiser Bandung 9 1/31/2024
Mar Honda Jazz Bandung 12 3/31/2024
Jan Honda CRV Bandung 6 2/28/2024
Feb Honda Brio Bandung 5 1/31/2024
Mar Suzuki Ertiga Bandung 11 3/31/2024
Apr Suzuki Swift Bandung 11 2/28/2024
Apr Mitsubishi Xpander Bandung 6 1/31/2024
Jan Mitsubishi Pajero Bandung 11 3/31/2024
Feb Nissan March Bandung 5 2/28/2024
Mar Nissan Juke Bandung 12 1/31/2024
Jan Toyota Avanza Surabaya 9 3/31/2024
Feb Toyota Innova Surabaya 12 2/28/2024
Mar Toyota Land Cruiser Surabaya 5 1/31/2024
Apr Honda Jazz Surabaya 5 3/31/2024
Apr Honda CRV Surabaya 5 2/28/2024
Jan Honda Brio Surabaya 8 1/31/2024
Feb Suzuki Ertiga Surabaya 7 3/31/2024
Mar Suzuki Swift Surabaya 5 2/28/2024
Jan Mitsubishi Xpander Surabaya 10 1/31/2024
Feb Mitsubishi Pajero Surabaya 6 3/31/2024
Mar Nissan March Surabaya 7 2/28/2024
Apr Nissan Juke Surabaya 6 1/31/2024
Apr Toyota Avanza Surabaya 10 3/31/2024
Jan Toyota Innova Surabaya 11 2/28/2024
Feb Toyota Land Cruiser Surabaya 11 1/31/2024
Mar Honda Jazz Surabaya 6 3/31/2024
Jan Honda CRV Surabaya 11 2/28/2024
Feb Honda Brio Surabaya 11 1/31/2024
Mar Suzuki Ertiga Surabaya 11 3/31/2024
Apr Suzuki Swift Surabaya 11 2/28/2024
Apr Mitsubishi Xpander Surabaya 9 1/31/2024
Jan Mitsubishi Pajero Surabaya 10 3/31/2024
Feb Nissan March Surabaya 10 2/28/2024
Mar Nissan Juke Surabaya 9 1/31/2024
Jan Toyota Avanza Surabaya 5 3/31/2024
Feb Toyota Innova Surabaya 11 2/28/2024
Mar Toyota Land Cruiser Surabaya 10 1/31/2024
Apr Honda Jazz Surabaya 8 3/31/2024
Apr Honda CRV Surabaya 6 2/28/2024
Jan Honda Brio Surabaya 6 1/31/2024
Feb Suzuki Ertiga Surabaya 8 3/31/2024
Mar Suzuki Swift Surabaya 12 2/28/2024
Jan Mitsubishi Xpander Surabaya 5 1/31/2024
Feb Mitsubishi Pajero Surabaya 9 3/31/2024
Mar Nissan March Surabaya 6 2/28/2024
Apr Nissan Juke Surabaya 12 1/31/2024
Penjualan Harga Modal
1,488,000,000 996,000,000
1,680,000,000 1,020,000,000
1,254,000,000 957,000,000
840,000,000 486,000,000
868,000,000 602,000,000
1,500,000,000 810,000,000
1,490,000,000 850,000,000
585,000,000 450,000,000
1,287,000,000 968,000,000
715,000,000 410,000,000
708,000,000 540,000,000
798,000,000 510,000,000
1,342,000,000 979,000,000
1,464,000,000 1,008,000,000
1,595,000,000 957,000,000
864,000,000 534,000,000
1,270,000,000 850,000,000
832,000,000 664,000,000
721,000,000 623,000,000
927,000,000 810,000,000
1,608,000,000 996,000,000
1,420,000,000 900,000,000
1,314,000,000 810,000,000
1,573,000,000 924,000,000
654,000,000 504,000,000
678,000,000 516,000,000
864,000,000 522,000,000
655,000,000 450,000,000
777,000,000 609,000,000
798,000,000 504,000,000
917,000,000 630,000,000
834,000,000 534,000,000
732,000,000 510,000,000
730,000,000 435,000,000
966,000,000 560,000,000
786,000,000 528,000,000
834,000,000 510,000,000
672,000,000 492,000,000
960,000,000 664,000,000
1,080,000,000 738,000,000
1,606,000,000 924,000,000
1,692,000,000 984,000,000
780,000,000 498,000,000
1,507,000,000 902,000,000
854,000,000 567,000,000
1,480,000,000 860,000,000
1,233,000,000 756,000,000
1,404,000,000 1,020,000,000
730,000,000 450,000,000
980,000,000 630,000,000
1,375,000,000 957,000,000
1,410,000,000 820,000,000
1,410,000,000 830,000,000
858,000,000 528,000,000
1,220,000,000 810,000,000
720,000,000 504,000,000
714,000,000 522,000,000
1,584,000,000 1,020,000,000
1,440,000,000 890,000,000
966,000,000 588,000,000
920,000,000 672,000,000
1,284,000,000 1,056,000,000
1,233,000,000 774,000,000
1,728,000,000 972,000,000
744,000,000 498,000,000
720,000,000 440,000,000
1,529,000,000 913,000,000
1,441,000,000 946,000,000
828,000,000 522,000,000
1,375,000,000 880,000,000
510,000,000 430,000,000
1,728,000,000 996,000,000
1,323,000,000 747,000,000
1,248,000,000 1,056,000,000
685,000,000 440,000,000
540,000,000 430,000,000
655,000,000 415,000,000
968,000,000 712,000,000
882,000,000 581,000,000
745,000,000 425,000,000
1,100,000,000 820,000,000
696,000,000 528,000,000
742,000,000 602,000,000
606,000,000 504,000,000
1,040,000,000 830,000,000
1,386,000,000 935,000,000
1,485,000,000 968,000,000
750,000,000 510,000,000
1,562,000,000 957,000,000
1,386,000,000 902,000,000
1,408,000,000 957,000,000
1,441,000,000 880,000,000
1,161,000,000 783,000,000
1,460,000,000 880,000,000
1,330,000,000 810,000,000
918,000,000 783,000,000
730,000,000 435,000,000
1,606,000,000 968,000,000
1,260,000,000 870,000,000
1,048,000,000 712,000,000
714,000,000 498,000,000
774,000,000 522,000,000
1,112,000,000 712,000,000
1,644,000,000 1,032,000,000
540,000,000 450,000,000
1,035,000,000 810,000,000
744,000,000 486,000,000
1,320,000,000 1,032,000,000

You might also like