7/21/2019 Pregunta 2 - Tabla Dinamica

1/9

Articulo - all -

Data

Sucursal Vendedor Sum - Venta Sum - Venta

Lima 15,435.00 ###

Elas 7,410.00 ###

osu! ",05.00 ###

$ira%lores 1,55.00 ###Al&erto ',(35.00 ###

Daniel 11,(0.00 ###

Surco 1',35.00 ###

)a&i*n ","75.00 ###

+iero 10,3(0.00 ###

Total Result 55,925.00 ###

7/21/2019 Pregunta 2 - Tabla Dinamica

2/9

Reporte de Ventas

N Pedido Fecha Mes Sucursal Vendedor Cdi!o

1 (0004 unio Lima osu! L1-001

1 (0004 unio Lima osu! +3-0011 (0004 unio Lima osu! +1-001

1 (0004 unio Lima osu! D1-001

1 (0004 unio Lima osu! +-001

1 (0004 unio Lima osu! S1-001

(30004 unio Lima Elas D1-001

(30004 unio Lima Elas L1-001

(30004 unio Lima Elas +1-001

(30004 unio Lima Elas +3-001

(30004 unio Lima Elas +-001

(30004 unio Lima Elas S1-001

3 710004 ulio Lima osu! +3-001

3 710004 ulio Lima osu! S1-0013 710004 ulio Lima osu! L1-001

3 710004 ulio Lima osu! +-001

3 710004 ulio Lima osu! D1-001

3 710004 ulio Lima osu! +1-001

4 70004 ulio Lima Elas +-001

4 70004 ulio Lima Elas L1-001

4 70004 ulio Lima Elas +1-001

4 70004 ulio Lima Elas S1-001

4 70004 ulio Lima Elas D1-001

4 70004 ulio Lima Elas +3-001

5 730004 ulio Lima osu! +1-001

5 730004 ulio Lima osu! L1-001

5 730004 ulio Lima osu! +3-001

5 730004 ulio Lima osu! S1-001

5 730004 ulio Lima osu! D1-001

5 730004 ulio Lima osu! +-001

( "'004 aosto Lima Elas +1-001

( "'004 aosto Lima Elas +-001

( "'004 aosto Lima Elas D1-001

( "'004 aosto Lima Elas L1-001

( "'004 aosto Lima Elas +3-001

( "'004 aosto Lima Elas S1-001

7 "1'004 aosto Lima osu! D1-0017 "1'004 aosto Lima osu! L1-001

7 "1'004 aosto Lima osu! +1-001

7 "1'004 aosto Lima osu! S1-001

7 "1'004 aosto Lima osu! +3-001

7 "1'004 aosto Lima osu! +-001

" "'004 aosto Lima Elas +1-001

" "'004 aosto Lima Elas +3-001

" "'004 aosto Lima Elas S1-001

" "'004 aosto Lima Elas L1-001

" "'004 aosto Lima Elas D1-001

" "'004 aosto Lima Elas +-001

' '"004 se/tiem&re $ira%lores Al&erto +3-001' '"004 se/tiem&re $ira%lores Al&erto L1-001

7/21/2019 Pregunta 2 - Tabla Dinamica

3/9

' '"004 se/tiem&re $ira%lores Al&erto +1-001

' '"004 se/tiem&re $ira%lores Al&erto S1-001

' '"004 se/tiem&re $ira%lores Al&erto D1-001

' '"004 se/tiem&re $ira%lores Al&erto +-001

10 '1"004 se/tiem&re $ira%lores Daniel L1-001

10 '1"004 se/tiem&re $ira%lores Daniel +-001

10 '1"004 se/tiem&re $ira%lores Daniel S1-001

10 '1"004 se/tiem&re $ira%lores Daniel D1-001

10 '1"004 se/tiem&re $ira%lores Daniel +1-001

10 '1"004 se/tiem&re $ira%lores Daniel +3-001

11 '"004 se/tiem&re $ira%lores Al&erto L1-001

11 '"004 se/tiem&re $ira%lores Al&erto +-001

11 '"004 se/tiem&re $ira%lores Al&erto D1-001

11 '"004 se/tiem&re $ira%lores Al&erto +1-001

11 '"004 se/tiem&re $ira%lores Al&erto S1-001

11 '"004 se/tiem&re $ira%lores Al&erto +3-001

1 10"004 octu&re $ira%lores Daniel +-001

1 10"004 octu&re $ira%lores Daniel +1-0011 10"004 octu&re $ira%lores Daniel S1-001

1 10"004 octu&re $ira%lores Daniel L1-001

1 10"004 octu&re $ira%lores Daniel D1-001

13 101"004 octu&re $ira%lores Al&erto +3-001

13 101"004 octu&re $ira%lores Al&erto L1-001

13 101"004 octu&re $ira%lores Al&erto +-001

13 101"004 octu&re $ira%lores Al&erto D1-001

13 101"004 octu&re $ira%lores Al&erto +1-001

13 101"004 octu&re $ira%lores Al&erto S1-001

14 10"004 octu&re $ira%lores Daniel +1-001

14 10"004 octu&re $ira%lores Daniel L1-001

14 10"004 octu&re $ira%lores Daniel D1-00114 10"004 octu&re $ira%lores Daniel +3-001

14 10"004 octu&re $ira%lores Daniel +-001

15 117004 noiem&re $ira%lores Al&erto +-001

15 117004 noiem&re $ira%lores Al&erto +1-001

15 117004 noiem&re $ira%lores Al&erto L1-001

15 117004 noiem&re $ira%lores Al&erto D1-001

15 117004 noiem&re $ira%lores Al&erto +3-001

1( 1117004 noiem&re $ira%lores Daniel +1-001

1( 1117004 noiem&re $ira%lores Daniel S1-001

1( 1117004 noiem&re $ira%lores Daniel +3-001

1( 1117004 noiem&re $ira%lores Daniel D1-001

1( 1117004 noiem&re $ira%lores Daniel L1-001

1( 1117004 noiem&re $ira%lores Daniel +-001

17 117004 noiem&re $ira%lores Al&erto S1-001

17 117004 noiem&re $ira%lores Al&erto +3-001

17 117004 noiem&re $ira%lores Al&erto L1-001

17 117004 noiem&re $ira%lores Al&erto +-001

17 117004 noiem&re $ira%lores Al&erto D1-001

17 117004 noiem&re $ira%lores Al&erto +1-001

1" 17004 diciem&re $ira%lores Daniel +-001

1" 17004 diciem&re $ira%lores Daniel +1-001

1" 17004 diciem&re $ira%lores Daniel L1-001

1" 17004 diciem&re $ira%lores Daniel S1-0011" 17004 diciem&re $ira%lores Daniel +3-001

7/21/2019 Pregunta 2 - Tabla Dinamica

4/9

1" 17004 diciem&re $ira%lores Daniel D1-001

1' 117004 diciem&re Surco +iero +-001

1' 117004 diciem&re Surco +iero S1-001

1' 117004 diciem&re Surco +iero D1-001

1' 117004 diciem&re Surco +iero L1-001

1' 117004 diciem&re Surco +iero +3-001

1' 117004 diciem&re Surco +iero +1-001

0 17004 diciem&re Surco )a&i*n D1-001

0 17004 diciem&re Surco )a&i*n L1-001

0 17004 diciem&re Surco )a&i*n +3-001

0 17004 diciem&re Surco )a&i*n +1-001

0 17004 diciem&re Surco )a&i*n +-001

1 1(004 enero Surco +iero +-001

1 1(004 enero Surco +iero +1-001

1 1(004 enero Surco +iero D1-001

1 1(004 enero Surco +iero L1-001

1 1(004 enero Surco +iero +3-001

1 1(004 enero Surco +iero S1-001 11(004 enero Surco )a&i*n L1-001

11(004 enero Surco )a&i*n D1-001

11(004 enero Surco )a&i*n +3-001

11(004 enero Surco )a&i*n S1-001

11(004 enero Surco )a&i*n +1-001

11(004 enero Surco )a&i*n +-001

3 1(004 enero Surco +iero D1-001

3 1(004 enero Surco +iero +-001

3 1(004 enero Surco +iero L1-001

3 1(004 enero Surco +iero +1-001

3 1(004 enero Surco +iero +3-001

3 1(004 enero Surco +iero S1-0014 5004 %e&rero Surco )a&i*n L1-001

4 5004 %e&rero Surco )a&i*n S1-001

4 5004 %e&rero Surco )a&i*n D1-001

4 5004 %e&rero Surco )a&i*n +3-001

4 5004 %e&rero Surco )a&i*n +-001

4 5004 %e&rero Surco )a&i*n +1-001

5 15004 %e&rero Surco +iero +1-001

5 15004 %e&rero Surco +iero +3-001

5 15004 %e&rero Surco +iero S1-001

5 15004 %e&rero Surco +iero L1-001

5 15004 %e&rero Surco +iero D1-001

5 15004 %e&rero Surco +iero +-001

( 15004 enero Surco )a&i*n +1-001

( 5004 %e&rero Surco )a&i*n +3-001

( 5004 %e&rero Surco )a&i*n S1-001

( 5004 %e&rero Surco )a&i*n L1-001

( 5004 %e&rero Surco )a&i*n D1-001

( 5004 %e&rero Surco )a&i*n +-001

7 3(004 maro Surco +iero D1-001

7 3(004 maro Surco +iero +3-001

7 3(004 maro Surco +iero +-001

7 3(004 maro Surco +iero L1-001

7 3(004 maro Surco +iero +1-0017 3(004 maro Surco +iero S1-001

7/21/2019 Pregunta 2 - Tabla Dinamica

5/9

" 31(004 maro Surco )a&i*n D1-001

" 31(004 maro Surco )a&i*n L1-001

" 31(004 maro Surco )a&i*n +1-001

" 31(004 maro Surco )a&i*n +3-001

" 31(004 maro Surco )a&i*n +-001

" 31(004 maro Surco )a&i*n S1-001

' 3(004 maro Surco +iero +-001

' 3(004 maro Surco +iero S1-001

' 3(004 maro Surco +iero D1-001

' 3(004 maro Surco +iero L1-001

' 3(004 maro Surco +iero +3-001

' 3(004 maro Surco +iero +1-001

30 45004 a&ril Surco )a&i*n +1-001

30 45004 a&ril Surco )a&i*n D1-001

30 45004 a&ril Surco )a&i*n +3-001

30 45004 a&ril Surco )a&i*n L1-001

30 45004 a&ril Surco )a&i*n +-001

30 45004 a&ril Surco )a&i*n S1-001

7/21/2019 Pregunta 2 - Tabla Dinamica

6/9

"rticulo nidad Cantidad Venta

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 363 olsa 10 10.00 30 300.00+ost-it 565 olsa 10 1.00 30 3(0.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 0 300.00

So&re $anila A4 iento 5.00 10 50.00

D-8 Son9 700 $ aa 10 .50 40 100.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 565 olsa 10 1.00 30 3(0.00

+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 56" olsa 10 15.00 0 300.00

So&re $anila A4 iento 5.00 10 50.00

+ost-it 363 olsa 10 10.00 50 500.00

So&re $anila A4 iento 5.00 50 1,50.00L*/i 2 )a&er astel aa 1 3.00 40 10.00

+ost-it 56" olsa 10 15.00 40 (00.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 565 olsa 10 1.00 30 3(0.00

+ost-it 56" olsa 10 15.00 40 (00.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 565 olsa 10 1.00 30 3(0.00

So&re $anila A4 iento 5.00 30 750.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 565 olsa 10 1.00 40 4"0.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 363 olsa 10 10.00 30 300.00

So&re $anila A4 iento 5.00 30 750.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 0 300.00

+ost-it 565 olsa 10 1.00 30 3(0.00

+ost-it 56" olsa 10 15.00 30 450.00

D-8 Son9 700 $ aa 10 .50 0 50.00

L*/i 2 )a&er astel aa 1 3.00 0 (0.00

+ost-it 363 olsa 10 10.00 0 00.00

So&re $anila A4 iento 5.00 0 500.00

D-8 Son9 700 $ aa 10 .50 40 100.00L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 565 olsa 10 1.00 30 3(0.00

So&re $anila A4 iento 5.00 30 750.00

+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 56" olsa 10 15.00 0 300.00

+ost-it 565 olsa 10 1.00 50 (00.00

+ost-it 363 olsa 10 10.00 40 400.00

So&re $anila A4 iento 5.00 40 1,000.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 0 300.00

+ost-it 363 olsa 10 10.00 40 400.00L*/i 2 )a&er astel aa 1 3.00 30 '0.00

Precionitario

7/21/2019 Pregunta 2 - Tabla Dinamica

7/9

+ost-it 565 olsa 10 1.00 30 3(0.00

So&re $anila A4 iento 5.00 30 750.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 0 300.00

L*/i 2 )a&er astel aa 1 3.00 40 10.00

+ost-it 56" olsa 10 15.00 40 (00.00

So&re $anila A4 iento 5.00 40 1,000.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 565 olsa 10 1.00 30 3(0.00

+ost-it 363 olsa 10 10.00 0 00.00

L*/i 2 )a&er astel aa 1 3.00 40 10.00

+ost-it 56" olsa 10 15.00 40 (00.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 565 olsa 10 1.00 30 3(0.00

So&re $anila A4 iento 5.00 30 750.00

+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 56" olsa 10 15.00 (0 '00.00

+ost-it 565 olsa 10 1.00 50 (00.00So&re $anila A4 iento 5.00 40 1,000.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 363 olsa 10 10.00 30 300.00

L*/i 2 )a&er astel aa 1 3.00 0 (0.00

+ost-it 56" olsa 10 15.00 0 300.00

D-8 Son9 700 $ aa 10 .50 10 5.00

+ost-it 565 olsa 10 1.00 10 10.00

So&re $anila A4 iento 5.00 10 50.00

+ost-it 565 olsa 10 1.00 40 4"0.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

D-8 Son9 700 $ aa 10 .50 0 50.00+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 56" olsa 10 15.00 10 150.00

+ost-it 56" olsa 10 15.00 70 1,050.00

+ost-it 565 olsa 10 1.00 50 (00.00

L*/i 2 )a&er astel aa 1 3.00 40 10.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 565 olsa 10 1.00 50 (00.00

So&re $anila A4 iento 5.00 50 1,50.00

+ost-it 363 olsa 10 10.00 40 400.00

D-8 Son9 700 $ aa 10 .50 30 75.00

L*/i 2 )a&er astel aa 1 3.00 0 (0.00

+ost-it 56" olsa 10 15.00 0 300.00

So&re $anila A4 iento 5.00 50 1,50.00

+ost-it 363 olsa 10 10.00 40 400.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 56" olsa 10 15.00 30 450.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 565 olsa 10 1.00 0 40.00

+ost-it 56" olsa 10 15.00 (0 '00.00

+ost-it 565 olsa 10 1.00 50 (00.00

L*/i 2 )a&er astel aa 1 3.00 40 10.00

So&re $anila A4 iento 5.00 40 1,000.00+ost-it 363 olsa 10 10.00 30 300.00

7/21/2019 Pregunta 2 - Tabla Dinamica

8/9

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 0 300.00

So&re $anila A4 iento 5.00 0 500.00

D-8 Son9 700 $ aa 10 .50 10 5.00

L*/i 2 )a&er astel aa 1 3.00 10 30.00

+ost-it 363 olsa 10 10.00 10 100.00

+ost-it 565 olsa 10 1.00 10 10.00

D-8 Son9 700 $ aa 10 .50 10 5.00

L*/i 2 )a&er astel aa 1 3.00 10 30.00

+ost-it 363 olsa 10 10.00 10 100.00

+ost-it 565 olsa 10 1.00 10 10.00

+ost-it 56" olsa 10 15.00 10 150.00

+ost-it 56" olsa 10 15.00 50 750.00

+ost-it 565 olsa 10 1.00 40 4"0.00

D-8 Son9 700 $ aa 10 .50 30 75.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 363 olsa 10 10.00 30 300.00

So&re $anila A4 iento 5.00 30 750.00L*/i 2 )a&er astel aa 1 3.00 30 '0.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 363 olsa 10 10.00 0 00.00

So&re $anila A4 iento 5.00 0 500.00

+ost-it 565 olsa 10 1.00 10 10.00

+ost-it 56" olsa 10 15.00 10 150.00

D-8 Son9 700 $ aa 10 .50 40 100.00

+ost-it 56" olsa 10 15.00 40 (00.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 565 olsa 10 1.00 30 3(0.00

+ost-it 363 olsa 10 10.00 0 00.00

So&re $anila A4 iento 5.00 0 500.00L*/i 2 )a&er astel aa 1 3.00 40 10.00

So&re $anila A4 iento 5.00 40 1,000.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 363 olsa 10 10.00 30 300.00

+ost-it 56" olsa 10 15.00 30 450.00

+ost-it 565 olsa 10 1.00 0 40.00

+ost-it 565 olsa 10 1.00 50 (00.00

+ost-it 363 olsa 10 10.00 40 400.00

So&re $anila A4 iento 5.00 40 1,000.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 10 150.00

+ost-it 565 olsa 10 1.00 50 (00.00

+ost-it 363 olsa 10 10.00 40 400.00

So&re $anila A4 iento 5.00 40 1,000.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

D-8 Son9 700 $ aa 10 .50 0 50.00

+ost-it 56" olsa 10 15.00 10 150.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 363 olsa 10 10.00 30 300.00

+ost-it 56" olsa 10 15.00 30 450.00

L*/i 2 )a&er astel aa 1 3.00 0 (0.00

+ost-it 565 olsa 10 1.00 0 40.00So&re $anila A4 iento 5.00 0 500.00

7/21/2019 Pregunta 2 - Tabla Dinamica

9/9

D-8 Son9 700 $ aa 10 .50 40 100.00

L*/i 2 )a&er astel aa 1 3.00 30 '0.00

+ost-it 565 olsa 10 1.00 30 3(0.00

+ost-it 363 olsa 10 10.00 0 00.00

+ost-it 56" olsa 10 15.00 10 150.00

So&re $anila A4 iento 5.00 10 50.00

+ost-it 56" olsa 10 15.00 0 300.00

So&re $anila A4 iento 5.00 0 500.00

D-8 Son9 700 $ aa 10 .50 10 5.00

L*/i 2 )a&er astel aa 1 3.00 10 30.00

+ost-it 363 olsa 10 10.00 10 100.00

+ost-it 565 olsa 10 1.00 10 10.00

+ost-it 565 olsa 10 1.00 40 4"0.00

D-8 Son9 700 $ aa 10 .50 30 75.00

+ost-it 363 olsa 10 10.00 30 300.00

L*/i 2 )a&er astel aa 1 3.00 0 (0.00

+ost-it 56" olsa 10 15.00 0 300.00

So&re $anila A4 iento 5.00 0 500.00