pregunta 2 - tabla dinamica
Post on 05-Feb-2018
225 Views
Preview:
TRANSCRIPT
-
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
top related