Scribd Logo
Upload

Welcome to Scribd!

  • 49 views

    Sample Data For Pivot Table

    Uploaded by

    Nguyên Văn
    The document contains sales data from January 1st, 2019 to August 3rd, 2019 listing the date, color, region, units sold, and sales for each transaction. It shows sales of various colors (silver, red, blue, green) across different regions (west, north, east, south) with the highest sales generally for silver and green colors. The data could be used to analyze the best selling colors and regions over time.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Sample Data For Pivot Table

    Uploaded by

    Nguyên Văn
    49 views5 pages
    The document contains sales data from January 1st, 2019 to August 3rd, 2019 listing the date, color, region, units sold, and sales for each transaction. It shows sales of various colors (silver, red, blue, green) across different regions (west, north, east, south) with the highest sales generally for silver and green colors. The data could be used to analyze the best selling colors and regions over time.

    Original Title

    Sample Data for Pivot Table

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains sales data from January 1st, 2019 to August 3rd, 2019 listing the date, color, region, units sold, and sales for each transaction. It shows sales of various colors (silver, red, blue, green) across different regions (west, north, east, south) with the highest sales generally for silver and green colors. The data could be used to analyze the best selling colors and regions over time.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    49 views5 pages

    Sample Data For Pivot Table

    Uploaded by

    Nguyên Văn
    The document contains sales data from January 1st, 2019 to August 3rd, 2019 listing the date, color, region, units sold, and sales for each transaction. It shows sales of various colors (silver, red, blue, green) across different regions (west, north, east, south) with the highest sales generally for silver and green colors. The data could be used to analyze the best selling colors and regions over time.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Sample sales data

    Date Color Region Units Sales


    1-Jan-19 Silver West 7 $105.00
    4-Jan-19 Silver North 4 $60.00
    6-Jan-19 Red West 3 $36.00
    9-Jan-19 Blue South 2 $26.00
    10-Jan-19 Silver East 6 $90.00
    13-Jan-19 Green West 5 $70.00
    16-Jan-19 Silver West 7 $105.00
    17-Jan-19 Green East 7 $98.00
    19-Jan-19 Green North 1 $14.00
    20-Jan-19 Blue North 2 $26.00
    22-Jan-19 Green West 3 $42.00
    23-Jan-19 Silver West 7 $105.00
    24-Jan-19 Green West 7 $98.00
    26-Jan-19 Green North 3 $42.00
    29-Jan-19 Blue North 5 $65.00
    1-Feb-19 Green East 3 $42.00
    3-Feb-19 Blue East 4 $52.00
    4-Feb-19 Silver West 1 $15.00
    7-Feb-19 Silver West 8 $120.00
    10-Feb-19 Red North 7 $84.00
    11-Feb-19 Red North 4 $48.00
    14-Feb-19 Silver North 7 $105.00
    16-Feb-19 Blue North 8 $104.00
    18-Feb-19 Blue West 8 $104.00
    21-Feb-19 Silver North 6 $90.00
    24-Feb-19 Silver West 5 $75.00
    25-Feb-19 Blue West 4 $52.00
    28-Feb-19 Green North 7 $98.00
    1-Mar-19 Green West 8 $112.00
    4-Mar-19 Green South 8 $112.00
    7-Mar-19 Blue North 2 $26.00
    10-Mar-19 Red South 1 $12.00
    12-Mar-19 Blue North 6 $78.00
    13-Mar-19 Silver West 1 $15.00
    16-Mar-19 Silver West 6 $90.00
    18-Mar-19 Blue East 4 $52.00
    19-Mar-19 Green West 8 $112.00
    21-Mar-19 Red South 6 $72.00
    23-Mar-19 Silver South 3 $45.00
    25-Mar-19 Green North 1 $14.00
    28-Mar-19 Silver East 3 $45.00
    31-Mar-19 Blue West 3 $39.00
    2-Apr-19 Silver West 4 $60.00
    4-Apr-19 Green North 7 $98.00
    7-Apr-19 Silver North 8 $120.00
    8-Apr-19 Red West 2 $24.00
    11-Apr-19 Silver West 2 $30.00
    13-Apr-19 Blue West 7 $91.00
    15-Apr-19 Silver North 6 $90.00
    16-Apr-19 Red East 8 $96.00
    17-Apr-19 Green North 6 $84.00
    19-Apr-19 Silver North 8 $120.00
    20-Apr-19 Green South 1 $14.00
    22-Apr-19 Silver West 7 $105.00
    23-Apr-19 Blue West 5 $65.00
    24-Apr-19 Silver South 1 $15.00
    26-Apr-19 Silver North 8 $120.00
    28-Apr-19 Blue East 6 $78.00
    29-Apr-19 Silver West 6 $90.00
    2-May-19 Green West 5 $70.00
    5-May-19 Silver West 5 $75.00
    6-May-19 Green North 1 $14.00
    7-May-19 Blue West 7 $91.00
    9-May-19 Green West 5 $70.00
    10-May-19 Blue West 5 $65.00
    11-May-19 Red North 5 $60.00
    12-May-19 Silver South 4 $60.00
    13-May-19 Red West 6 $72.00
    16-May-19 Green South 5 $70.00
    17-May-19 Silver West 8 $120.00
    19-May-19 Silver West 5 $75.00
    21-May-19 Green West 8 $112.00
    22-May-19 Red North 3 $36.00
    23-May-19 Blue East 2 $26.00
    25-May-19 Silver North 3 $45.00
    28-May-19 Red North 3 $36.00
    29-May-19 Silver North 8 $120.00
    30-May-19 Silver West 2 $30.00
    2-Jun-19 Silver North 7 $105.00
    5-Jun-19 Silver West 4 $60.00
    6-Jun-19 Red East 1 $12.00
    9-Jun-19 Silver North 3 $45.00
    12-Jun-19 Silver West 7 $105.00
    14-Jun-19 Red East 2 $24.00
    17-Jun-19 Red North 3 $36.00
    19-Jun-19 Green North 7 $98.00
    22-Jun-19 Silver North 7 $105.00
    25-Jun-19 Green West 4 $56.00
    27-Jun-19 Blue North 6 $78.00
    28-Jun-19 Blue West 1 $13.00
    29-Jun-19 Red East 3 $36.00
    2-Jul-19 Blue North 1 $13.00
    3-Jul-19 Silver North 7 $105.00
    5-Jul-19 Blue North 7 $91.00
    7-Jul-19 Silver West 3 $45.00
    9-Jul-19 Green West 1 $14.00
    11-Jul-19 Blue South 8 $104.00
    12-Jul-19 Red North 2 $24.00
    15-Jul-19 Green West 7 $98.00
    17-Jul-19 Red South 1 $12.00
    19-Jul-19 Silver East 7 $105.00
    22-Jul-19 Silver West 6 $90.00
    23-Jul-19 Silver North 7 $105.00
    24-Jul-19 Silver North 4 $60.00
    27-Jul-19 Silver South 3 $45.00
    30-Jul-19 Silver South 6 $90.00
    1-Aug-19 Red North 8 $96.00
    3-Aug-19 Blue South 6 $78.00
    Số lượng Đang sản Có thể sử dụng / Tồn
    Sản phẩm xuất kho tổng

    Hộp Sản phẩm 1.000,00 Đơn vị 0 0,00 / 0,00

    –[01] Giấy Đã In 100,00 kg 500 0,00 / 0,00

    –[a] Giấy Cuộn Đã Xả 100,00 kg 2941 500,00 / 500,00

    Giấy cuộn 120,00 kg 3.530,00 / 3.530,00

    [b] Mực In 100,00 kg 800,00 / 800,00

    [02] Keo Dán 50,00 kg 0,00 / 0,00

    Chi phí
    Tồn kho Tồn kho Tồn kho Khả dụng Tuyến cung ứng Chi phí sản phẩm
    Nguyên liệu Thứ phẩm Thành phẩm

    0 0 0 Không có hàng Sản xuất 55.000.000 ₫

    0 0 0 Không có hàng Sản xuất 2.000.000 ₫

    200 300 0 Khả dụng Sản xuất 1.500.000 ₫

    3530 0 0 Khả dụng Mua: Paper Inc 1.200.000 ₫

    100 0 0 Khả dụng Mua: INK Inc 4.000.000 ₫

    0 0 0 Dự kiến hàng về 30/12/2022 Mua: INK Inc 2.500.000 ₫

    55.000 đ 

    You might also like