12
Suma de Importe Ciudad Vendedor Lima Breña Jesus Maria Magdalena Miraflores Vega, Ana 3,795.00 1,260.00 1,480.00 3,060.00 1,710.00 Silva, Jorge 4,170.00 50.00 720.00 3,110.00 1,860.00 Jara, Lino 4,010.00 570.00 820.00 1,750.00 900.00 Moran, Marcos 4,180.00 160.00 250.00 500.00 1,210.00 Navarro, Angel 260.00 2,770.00 1,980.00 Martinez, Carlos 1,570.00 140.00 480.00 1,390.00 Mena, Luis 1,080.00 950.00 890.00 Suazo, Jarol 410.00 45.00 630.00 Total Result 19,475.00 2,180.00 3,270.00 12,665.00 10,570.00

Tablas Dinamicas

Embed Size (px)

DESCRIPTION

Tablas Dinamicas

Citation preview

Page 1: Tablas Dinamicas

Suma de Importe CiudadVendedor Lima Breña Jesus Maria Magdalena Miraflores San IsidroVega, Ana 3,795.00 1,260.00 1,480.00 3,060.00 1,710.00 790.00Silva, Jorge 4,170.00 50.00 720.00 3,110.00 1,860.00 830.00Jara, Lino 4,010.00 570.00 820.00 1,750.00 900.00 220.00Moran, Marcos 4,180.00 160.00 250.00 500.00 1,210.00Navarro, Angel 260.00 2,770.00 1,980.00Martinez, Carlos 1,570.00 140.00 480.00 1,390.00Mena, Luis 1,080.00 950.00 890.00Suazo, Jarol 410.00 45.00 630.00Total Result 19,475.00 2,180.00 3,270.00 12,665.00 10,570.00 1,840.00

Page 2: Tablas Dinamicas

Total Result12,095.0010,740.00

8,270.006,300.005,010.003,580.002,920.001,085.00

50,000.00

Page 3: Tablas Dinamicas

Mes Venta Vendedor Ciudad Cantidad ImporteApr-03 Vega, Ana San Isidro 50 180.00Apr-03 Jara, Lino Lima 35 10.00Apr-03 Navarro, Angel Miraflores 20 250.00Apr-03 Jara, Lino Miraflores 15 30.00Apr-03 Jara, Lino Magdalena 40 40.00Apr-03 Mena, Luis Magdalena 62 750.00Apr-03 Moran, Marcos Magdalena 52 350.00Apr-03 Moran, Marcos Lima 30 65.00Apr-03 Silva, Jorge Lima 85 30.00Apr-03 Vega, Ana Lima 42 60.00Apr-03 Vega, Ana Breña 26 80.00Apr-03 Martinez, Carlos Magdalena 65 110.00Apr-03 Vega, Ana San Isidro 21 130.00Apr-03 Moran, Marcos Lima 26 210.00Apr-03 Jara, Lino Miraflores 57 60.00Apr-03 Jara, Lino Lima 45 70.00Apr-03 Silva, Jorge Magdalena 18 150.00Apr-03 Navarro, Angel Magdalena 35 320.00Apr-03 Vega, Ana Lima 69 620.00Apr-03 Jara, Lino Miraflores 68 40.00Apr-03 Vega, Ana Lima 34 50.00Apr-03 Jara, Lino Lima 16 850.00Apr-03 Jara, Lino Magdalena 28 20.00Apr-03 Navarro, Angel Magdalena 39 280.00Apr-03 Silva, Jorge Lima 37 780.00Apr-03 Silva, Jorge Lima 14 90.00Apr-03 Vega, Ana Lima 25 120.00Apr-03 Jara, Lino Miraflores 36 180.00Apr-03 Suazo, Jarol Miraflores 39 250.00Apr-03 Vega, Ana Lima 38 550.00

May-03 Jara, Lino Miraflores 31 90.00May-03 Vega, Ana Jesus Maria 28 460.00May-03 Silva, Jorge Lima 27 80.00May-03 Martinez, Carlos Magdalena 72 120.00May-03 Navarro, Angel Miraflores 76 750.00May-03 Silva, Jorge Lima 75 360.00May-03 Vega, Ana Magdalena 48 530.00May-03 Silva, Jorge Jesus Maria 50 240.00May-03 Vega, Ana Lima 35 85.00May-03 Moran, Marcos Lima 20 220.00May-03 Vega, Ana Breña 15 360.00May-03 Silva, Jorge Miraflores 40 60.00May-03 Silva, Jorge Magdalena 62 260.00May-03 Vega, Ana Miraflores 52 250.00May-03 Jara, Lino Magdalena 30 140.00May-03 Moran, Marcos Miraflores 85 240.00May-03 Navarro, Angel Magdalena 42 50.00May-03 Silva, Jorge San Isidro 26 30.00May-03 Vega, Ana Lima 65 140.00

Page 4: Tablas Dinamicas

May-03 Jara, Lino Magdalena 21 100.00May-03 Silva, Jorge Miraflores 26 430.00May-03 Navarro, Angel Miraflores 57 150.00May-03 Vega, Ana Magdalena 45 680.00May-03 Martinez, Carlos Lima 18 150.00May-03 Silva, Jorge Lima 35 630.00May-03 Martinez, Carlos Lima 69 130.00May-03 Silva, Jorge Lima 68 180.00May-03 Martinez, Carlos Miraflores 34 230.00May-03 Navarro, Angel Miraflores 16 250.00May-03 Navarro, Angel Magdalena 28 950.00Jun-03 Silva, Jorge Miraflores 39 390.00Jun-03 Jara, Lino Lima 37 360.00Jun-03 Silva, Jorge Lima 14 840.00Jun-03 Silva, Jorge San Isidro 25 260.00Jun-03 Vega, Ana Magdalena 36 850.00Jun-03 Jara, Lino Lima 39 40.00Jun-03 Martinez, Carlos Lima 38 20.00Jun-03 Vega, Ana San Isidro 31 140.00Jun-03 Mena, Luis Lima 28 70.00Jun-03 Mena, Luis Miraflores 27 110.00Jun-03 Moran, Marcos Breña 72 160.00Jun-03 Jara, Lino Lima 76 60.00Jun-03 Moran, Marcos Lima 75 130.00Jun-03 Moran, Marcos Lima 48 20.00Jun-03 Moran, Marcos Miraflores 50 230.00Jun-03 Martinez, Carlos Miraflores 35 50.00Jun-03 Moran, Marcos Magdalena 20 150.00Jun-03 Silva, Jorge Lima 15 320.00Jun-03 Silva, Jorge Jesus Maria 40 160.00Jun-03 Jara, Lino Miraflores 62 380.00Jun-03 Jara, Lino Magdalena 52 280.00Jun-03 Jara, Lino Lima 30 50.00Jun-03 Silva, Jorge Magdalena 85 580.00Jun-03 Vega, Ana Lima 42 590.00Jun-03 Martinez, Carlos Miraflores 26 10.00Jun-03 Moran, Marcos Lima 65 95.00Jun-03 Martinez, Carlos Magdalena 21 250.00Jun-03 Suazo, Jarol Magdalena 26 45.00Jun-03 Vega, Ana Miraflores 57 60.00Jun-03 Vega, Ana Jesus Maria 45 280.00Jul-03 Vega, Ana Jesus Maria 18 280.00Jul-03 Silva, Jorge Lima 35 70.00Jul-03 Martinez, Carlos Lima 69 190.00Jul-03 Vega, Ana Lima 68 50.00Jul-03 Jara, Lino Magdalena 34 10.00Jul-03 Navarro, Angel Miraflores 16 270.00Jul-03 Silva, Jorge Lima 28 450.00Jul-03 Silva, Jorge Miraflores 39 290.00Jul-03 Silva, Jorge Miraflores 37 180.00

Page 5: Tablas Dinamicas

Jul-03 Jara, Lino Jesus Maria 14 140.00Jul-03 Silva, Jorge Breña 25 50.00Jul-03 Silva, Jorge Magdalena 36 40.00Jul-03 Vega, Ana Lima 39 50.00Jul-03 Jara, Lino Miraflores 38 120.00Jul-03 Silva, Jorge Lima 31 20.00Jul-03 Vega, Ana San Isidro 28 340.00Jul-03 Moran, Marcos Lima 27 950.00Jul-03 Silva, Jorge Magdalena 72 150.00Jul-03 Jara, Lino Magdalena 76 260.00Jul-03 Silva, Jorge Magdalena 75 420.00Jul-03 Jara, Lino Lima 48 740.00Jul-03 Mena, Luis Lima 50 850.00Jul-03 Martinez, Carlos Breña 35 140.00Jul-03 Moran, Marcos Lima 20 750.00Jul-03 Martinez, Carlos Miraflores 15 240.00Jul-03 Navarro, Angel Magdalena 40 30.00Jul-03 Jara, Lino Magdalena 62 70.00Jul-03 Jara, Lino San Isidro 52 220.00Jul-03 Silva, Jorge Magdalena 30 120.00Jul-03 Martinez, Carlos Miraflores 85 220.00

Aug-03 Silva, Jorge Miraflores 42 30.00Aug-03 Jara, Lino Lima 26 760.00Aug-03 Silva, Jorge Magdalena 65 330.00Aug-03 Jara, Lino Lima 21 80.00Aug-03 Silva, Jorge Magdalena 26 440.00Aug-03 Jara, Lino Magdalena 57 80.00Aug-03 Silva, Jorge Miraflores 45 120.00Aug-03 Moran, Marcos Lima 18 170.00Aug-03 Vega, Ana Miraflores 35 150.00Aug-03 Jara, Lino Magdalena 69 420.00Aug-03 Jara, Lino Breña 68 90.00Aug-03 Silva, Jorge Jesus Maria 34 320.00Aug-03 Silva, Jorge Magdalena 16 510.00Aug-03 Vega, Ana Jesus Maria 28 20.00Aug-03 Jara, Lino Lima 39 110.00Aug-03 Moran, Marcos Lima 37 50.00Aug-03 Navarro, Angel Magdalena 14 850.00Aug-03 Moran, Marcos Lima 25 550.00Aug-03 Navarro, Angel Lima 36 250.00Aug-03 Moran, Marcos Miraflores 39 140.00Aug-03 Martinez, Carlos Miraflores 38 210.00Aug-03 Moran, Marcos Miraflores 31 350.00Aug-03 Vega, Ana Miraflores 28 620.00Aug-03 Jara, Lino Lima 27 160.00Aug-03 Silva, Jorge Magdalena 72 60.00Aug-03 Mena, Luis Lima 76 10.00Aug-03 Moran, Marcos Lima 75 190.00Aug-03 Navarro, Angel Miraflores 48 260.00Aug-03 Suazo, Jarol Lima 42 410.00

Page 6: Tablas Dinamicas

Aug-03 Moran, Marcos Lima 26 150.00Sep-03 Martinez, Carlos Miraflores 65 30.00Sep-03 Mena, Luis Miraflores 21 80.00Sep-03 Martinez, Carlos Lima 26 170.00Sep-03 Mena, Luis Lima 57 150.00Sep-03 Jara, Lino Lima 45 720.00Sep-03 Vega, Ana Lima 18 50.00Sep-03 Vega, Ana Miraflores 35 540.00Sep-03 Moran, Marcos Miraflores 69 250.00Sep-03 Silva, Jorge Miraflores 68 70.00Sep-03 Vega, Ana Magdalena 34 340.00Sep-03 Vega, Ana Breña 16 820.00Sep-03 Jara, Lino Jesus Maria 28 240.00Sep-03 Navarro, Angel Miraflores 39 50.00Sep-03 Silva, Jorge Miraflores 37 80.00Sep-03 Mena, Luis Magdalena 14 60.00Sep-03 Vega, Ana Miraflores 25 20.00Sep-03 Jara, Lino Jesus Maria 36 440.00Sep-03 Martinez, Carlos Lima 39 20.00Sep-03 Navarro, Angel Lima 38 10.00Sep-03 Vega, Ana Jesus Maria 31 120.00Sep-03 Mena, Luis Magdalena 28 90.00Sep-03 Moran, Marcos Lima 27 180.00Sep-03 Martinez, Carlos Miraflores 72 250.00Sep-03 Suazo, Jarol Miraflores 76 380.00Sep-03 Moran, Marcos Jesus Maria 75 250.00Sep-03 Martinez, Carlos Miraflores 48 150.00Sep-03 Mena, Luis Miraflores 68 650.00Sep-03 Silva, Jorge San Isidro 34 460.00Sep-03 Martinez, Carlos Lima 16 160.00Sep-03 Jara, Lino Breña 28 60.00Oct-03 Vega, Ana Lima 39 750.00Oct-03 Mena, Luis Miraflores 37 50.00Oct-03 Martinez, Carlos Lima 14 550.00Oct-03 Mena, Luis Magdalena 25 50.00Oct-03 Silva, Jorge Lima 36 50.00Oct-03 Vega, Ana Magdalena 39 660.00Oct-03 Silva, Jorge Miraflores 38 210.00Oct-03 Navarro, Angel Magdalena 31 290.00Oct-03 Vega, Ana Lima 28 620.00Oct-03 Vega, Ana Lima 27 60.00Oct-03 Jara, Lino Breña 72 420.00Oct-03 Moran, Marcos Lima 76 450.00Oct-03 Jara, Lino Magdalena 75 240.00Oct-03 Silva, Jorge Lima 48 270.00Oct-03 Silva, Jorge Magdalena 45 50.00Oct-03 Vega, Ana Miraflores 57 70.00Oct-03 Silva, Jorge San Isidro 59 80.00Oct-03 Vega, Ana Jesus Maria 62 320.00Oct-03 Jara, Lino Magdalena 50 90.00

Page 7: Tablas Dinamicas

Oct-03 Martinez, Carlos Lima 32 180.00

Page 8: Tablas Dinamicas

ProductoGlobosGlobosGlobosGlobosGlobosVasosVasosVasosVasosVelasVelasVelasVelasVelasVelasPlatosPlatosPlatosPlatosTarjetasTarjetasServilletasServilletasServilletasGlobosGlobosGlobosGlobosGlobosGlobosGlobosVasosVasosVasosVasosVasosVasosVelasVelasVelasPlatosPlatosPlatosPlatosTarjetasTarjetasTarjetasServilletasServilletas

base de datos :tablas dinamicas

podria llamarse -cuadro resumido

puede ser Tabla dinamica oGrafico dinamico

insertar tabla dinamica.aceptar

opcionesmostrar

diseño de tablas dinamicas clasica

para grafico dinamico opciones

grafico dinamico

Page 9: Tablas Dinamicas

ServilletasGlobosGlobosVasosVasosVasosVelasVelasVelasVelasVelasVelasPlatosPlatosPlatosPlatosTarjetasTarjetasServilletasServilletasServilletasServilletasGlobosGlobosGlobosGlobosVasosVasosVasosVelasVelasVelasVelasPlatosPlatosTarjetasTarjetasTarjetasTarjetasServilletasServilletasGlobosGlobosGlobosGlobosVasosVelasVelasPlatosTarjetas

Page 10: Tablas Dinamicas

TarjetasServilletasServilletasServilletasGlobosVasosVasosVasosVasosVasosVasosVelasVelasVelasVelasVelasVelasVelasPlatosPlatosPlatosPlatosTarjetasTarjetasTarjetasServilletasServilletasServilletasServilletasServilletasGlobosGlobosGlobosGlobosVasosVasosVasosVasosVelasVelasPlatosPlatosPlatosTarjetasTarjetasTarjetasServilletasServilletasServilletasServilletas

Page 11: Tablas Dinamicas

GlobosVasosPlatosPlatosTarjetasServilletasServilletasGlobosGlobosGlobosVasosVasosVasosVasosVasosVelasVelasVelasVelasVelasPlatosPlatosPlatosPlatosPlatosServilletasServilletasGlobosGlobosGlobosVasosVasosVelasPlatosPlatosPlatosServilletasServilletasServilletasServilletasGlobosGlobosGlobosGlobosGlobosGlobosGlobosVasosVasosVasos

Page 12: Tablas Dinamicas

Vasos

Page 13: Tablas Dinamicas

base de datos :tablas dinamicas

podria llamarse -cuadro resumido

puede ser Tabla dinamica oGrafico dinamico

insertar tabla dinamica.aceptar

opcionesmostrar

diseño de tablas dinamicas clasica

para grafico dinamico opciones

grafico dinamico