Filial Sum - Valor Filial Cliente

Cuiabá 97885 Cuiabá ClienteA

Primavera 87003 ClienteB
Rondonópolis 422383 ClienteC
Rondonópolis 46630 ClienteD
Total Result 653901 ClienteE
Primavera ClienteA
ClienteB
ClienteC
Esta forma representa uma segmentação de
dados. Segmentações de dados têm suporte no ClienteD
Excel 2010 ou versões posteriores. ClienteE
Rondonópolis ClienteA
\Se a forma tiver sido modificada em uma
versão anterior do Excel, ou se a pasta de ClienteB
trabalho tiver sido salva no Excel 2003 ou ClienteC
versões anteriores, a segmentação de dados não
ClienteD
poderá ser usada.
ClienteE
Rondonópolis ClienteA
Total Result

Linha do tempo: Funciona em Excel 2013 ou

superior. Não mover ou redimensionar.
 Vendedor João Vendedor

Sum - Valor Filial Cliente Sum - Valor Sum - Valor

31192 Cuiabá ClienteA 16716 Filial
20813 ClienteB 4166 Cuiabá
26092 ClienteC 13169
12041 ClienteD 12041
7747 Rondonópolis ClienteA 6393
6852 ClienteB 167766 Rondonópolis
23981 ClienteD 8178
30584 ClienteE 5887
5873 Rondonópolis ClienteA 46630
19713 Total Result 280946 Rondonópolis
17398 Total Result
191135
163181
31523
19146
46630
653901
João

CódigoProduto
Cliente 20 327 456 Total Result
ClienteA 8483 8233 16716
ClienteB 4166 4166
ClienteC 13169 13169
ClienteD 12041 12041
ClienteA 6393 6393
ClienteB 167766 167766
ClienteD 8178 8178
ClienteE 5887 5887
ClienteA 46630 46630
16207 182136 82603 280946
Vendedor Average - Preço Unit
André 0.089393017869725
João 0.105316500744744
Paulo 0.116549692625082
Ricardo 0.10892901084051
Total Result 0.104890069883019
 653,901.00
CódigoProduto Filial documento Data Cliente Vendedor Valor Volume Preço Unit cep cliente
456 Rondonópolis 3600 3/1/2019 ClienteA João 46,630.00 30,074.00 0.16 04843-425
327 Cuiabá 4409 2/1/2019 ClienteB André 1,151.00 30,159.00 0.04 22041-011
20 Primavera 2606 1/1/2019 ClienteC Ricardo 4,913.00 26,715.00 0.18 78005-020
327 Primavera 1387 3/1/2019 ClienteC Paulo 4,735.00 27,284.00 0.17 78005-020
327 Cuiabá 3481 4/1/2019 ClienteA João 1,190.00 33,555.00 0.04 04843-425
456 Rondonópolis 4877 3/1/2019 ClienteB André 3,887.00 26,500.00 0.15 22041-011
456 Cuiabá 1402 4/1/2019 ClienteB Ricardo 1,480.00 30,407.00 0.05 22041-011
456 Rondonópolis 3066 2/1/2019 ClienteD Paulo 2,675.00 31,980.00 0.08 78756-000
20 Cuiabá 4441 1/1/2019 ClienteD João 3,132.00 27,056.00 0.12 78756-000
20 Primavera 1656 3/1/2019 ClienteE André 2,521.00 31,290.00 0.08 78710-129
456 Rondonópolis 1730 3/1/2019 ClienteE Ricardo 1,361.00 27,385.00 0.05 78710-129
456 Rondonópolis 1544 2/1/2019 ClienteA Paulo 4,962.00 32,143.00 0.15 04843-425
327 Rondonópolis 4775 1/1/2019 ClienteB João 1,645.00 27,053.00 0.06 22041-011
327 Cuiabá 1431 3/1/2019 ClienteC André 1,320.00 29,345.00 0.04 78005-020
20 Primavera 3035 4/1/2019 ClienteA Ricardo 2,118.00 25,228.00 0.08 04843-425
456 Primavera 4942 3/1/2019 ClienteB Paulo 1,486.00 34,967.00 0.04 22041-011
456 Cuiabá 1890 4/1/2019 ClienteC João 4,358.00 32,864.00 0.13 78005-020
456 Rondonópolis 4795 2/1/2019 ClienteC André 3,032.00 32,677.00 0.09 78005-020
327 Cuiabá 4583 1/1/2019 ClienteA Ricardo 4,903.00 29,334.00 0.17 04843-425
20 Rondonópolis 1927 3/1/2019 ClienteB Paulo 2,253.00 32,357.00 0.07 22041-011
20 Cuiabá 1097 3/1/2019 ClienteB João 2,170.00 33,622.00 0.06 22041-011
456 Primavera 4922 2/1/2019 ClienteD André 3,878.00 34,072.00 0.11 78756-000
327 Rondonópolis 2914 1/1/2019 ClienteD Ricardo 3,262.00 26,575.00 0.12 78756-000
20 Rondonópolis 1175 3/1/2019 ClienteE Paulo 3,478.00 30,615.00 0.11 78710-129
327 Rondonópolis 4089 4/1/2019 ClienteE João 4,329.00 32,964.00 0.13 78710-129
327 Cuiabá 3454 3/1/2019 ClienteA André 1,521.00 32,152.00 0.05 04843-425
456 Primavera 1314 4/1/2019 ClienteB Ricardo 4,251.00 27,378.00 0.16 22041-011
456 Primavera 4152 2/1/2019 ClienteC Paulo 2,220.00 28,518.00 0.08 78005-020
456 Cuiabá 2120 1/1/2019 ClienteA João 1,841.00 29,668.00 0.06 04843-425
20 Rondonópolis 2414 3/1/2019 ClienteB André 3,216.00 32,593.00 0.10 22041-011
20 Cuiabá 2418 3/1/2019 ClienteC Ricardo 4,662.00 32,889.00 0.14 78005-020
456 Rondonópolis 3298 2/1/2019 ClienteC Paulo 2,002.00 32,003.00 0.06 78005-020
456 Cuiabá 3282 1/1/2019 ClienteA João 1,098.00 26,699.00 0.04 04843-425
327 Primavera 3377 3/1/2019 ClienteB André 1,941.00 25,652.00 0.08 22041-011
327 Rondonópolis 1826 4/1/2019 ClienteB Ricardo 2,497.00 30,446.00 0.08 22041-011
20 Rondonópolis 2982 3/1/2019 ClienteD Paulo 1,489.00 34,831.00 0.04 78756-000
456 Rondonópolis 3622 4/1/2019 ClienteD João 4,708.00 34,770.00 0.14 78756-000
456 Cuiabá 2889 2/1/2019 ClienteE André 4,926.00 32,989.00 0.15 78710-129
456 Primavera 1690 1/1/2019 ClienteE Ricardo 2,838.00 33,135.00 0.09 78710-129
327 Primavera 3479 3/1/2019 ClienteE Paulo 4,645.00 28,953.00 0.16 78710-129
456 Rondonópolis 4501 3/1/2019 ClienteA João 2,150.00 30,659.00 0.07 04843-425
327 Cuiabá 2455 2/1/2019 ClienteB André 1,564.00 27,112.00 0.06 22041-011
20 Primavera 2200 1/1/2019 ClienteC Ricardo 2,112.00 33,446.00 0.06 78005-020
327 Primavera 4185 3/1/2019 ClienteC Paulo 4,079.00 32,475.00 0.13 78005-020
327 Cuiabá 4129 4/1/2019 ClienteA João 3,581.00 25,835.00 0.14 04843-425
456 Rondonópolis 1658 3/1/2019 ClienteB André 1,469.00 33,725.00 0.04 22041-011
456 Cuiabá 2019 4/1/2019 ClienteB Ricardo 3,867.00 28,456.00 0.14 22041-011
456 Rondonópolis 1182 2/1/2019 ClienteD Paulo 4,828.00 25,067.00 0.19 78756-000
20 Cuiabá 3260 1/1/2019 ClienteD João 4,058.00 34,742.00 0.12 78756-000
20 Primavera 2426 3/1/2019 ClienteE André 1,502.00 34,395.00 0.04 78710-129
456 Rondonópolis 1404 3/1/2019 ClienteE Ricardo 2,642.00 32,556.00 0.08 78710-129
456 Rondonópolis 3670 2/1/2019 ClienteA Paulo 3,349.00 28,995.00 0.12 04843-425
327 Rondonópolis 1615 1/1/2019 ClienteB João 161,500.00 31,369.00 0.05 22041-011
327 Cuiabá 3130 3/1/2019 ClienteC André 2,345.00 32,017.00 0.07 78005-020
20 Primavera 1233 4/1/2019 ClienteA Ricardo 1,717.00 30,690.00 0.06 04843-425
456 Primavera 2356 3/1/2019 ClienteB Paulo 4,177.00 25,276.00 0.17 22041-011
456 Cuiabá 4426 4/1/2019 ClienteC João 3,997.00 30,194.00 0.13 78005-020
456 Rondonópolis 1398 2/1/2019 ClienteC André 151,515.00 31,525.00 0.13 78005-020
327 Cuiabá 1682 1/1/2019 ClienteA Ricardo 3,166.00 30,315.00 0.10 04843-425
20 Rondonópolis 3782 3/1/2019 ClienteB Paulo 2,105.00 33,518.00 0.06 22041-011
20 Cuiabá 1805 3/1/2019 ClienteB João 1,996.00 28,235.00 0.07 22041-011
456 Primavera 3471 2/1/2019 ClienteD André 1,995.00 33,359.00 0.06 78756-000
327 Rondonópolis 4413 1/1/2019 ClienteD Ricardo 3,899.00 29,481.00 0.13 78756-000
20 Rondonópolis 4776 3/1/2019 ClienteE Paulo 4,519.00 32,076.00 0.14 78710-129
327 Rondonópolis 3667 4/1/2019 ClienteE João 1,558.00 29,890.00 0.05 78710-129
327 Cuiabá 1023 3/1/2019 ClienteA André 4,886.00 29,301.00 0.17 04843-425
456 Primavera 1604 4/1/2019 ClienteB Ricardo 3,476.00 26,243.00 0.13 22041-011
456 Primavera 1477 2/1/2019 ClienteC Paulo 4,913.00 28,882.00 0.17 78005-020
456 Cuiabá 4287 1/1/2019 ClienteA João 4,054.00 30,124.00 0.13 04843-425
20 Rondonópolis 3728 3/1/2019 ClienteB André 1,282.00 29,296.00 0.04 22041-011
20 Cuiabá 2132 3/1/2019 ClienteC Ricardo 3,185.00 30,568.00 0.10 78005-020
456 Rondonópolis 1805 2/1/2019 ClienteC Paulo 3,200.00 31,994.00 0.10 78005-020
456 Cuiabá 1462 1/1/2019 ClienteA João 1,240.00 25,377.00 0.05 04843-425
327 Primavera 2045 3/1/2019 ClienteB André 4,894.00 30,568.00 0.16 22041-011
327 Rondonópolis 4023 4/1/2019 ClienteB Ricardo 3,614.00 30,502.00 0.12 22041-011
20 Rondonópolis 4299 3/1/2019 ClienteD Paulo 4,778.00 26,161.00 0.18 78756-000
456 Rondonópolis 3927 4/1/2019 ClienteD João 3,470.00 26,624.00 0.13 78756-000
456 Cuiabá 3147 2/1/2019 ClienteE André 2,821.00 32,106.00 0.09 78710-129
456 Primavera 1535 1/1/2019 ClienteE Ricardo 4,565.00 25,766.00 0.18 78710-129
CódigoProduto Filial documento Data Cliente Vendedor Valor Volume Preço Unit cep cliente
327 Primavera 2401 3/1/2019 ClienteE Paulo 1,826.00 25,939.00 0.07 78710-129
456 Rondonópolis 4025 3/1/2019 ClienteA João 4,243.00 31,166.00 0.14 04843-425
327 Cuiabá 1320 2/1/2019 ClienteB André 4,431.00 31,939.00 0.14 22041-011
20 Primavera 4988 1/1/2019 ClienteC Ricardo 2,717.00 32,203.00 0.08 78005-020
327 Primavera 4634 3/1/2019 ClienteC Paulo 4,895.00 26,393.00 0.19 78005-020
327 Cuiabá 4350 4/1/2019 ClienteA João 3,712.00 26,418.00 0.14 04843-425
456 Rondonópolis 3676 3/1/2019 ClienteB André 3,046.00 29,582.00 0.10 22041-011
456 Cuiabá 1206 4/1/2019 ClienteB Ricardo 4,154.00 27,804.00 0.15 22041-011
456 Rondonópolis 3264 2/1/2019 ClienteD Paulo 2,414.00 30,078.00 0.08 78756-000
20 Cuiabá 4823 1/1/2019 ClienteD João 4,851.00 27,930.00 0.17 78756-000
20 Primavera 1453 3/1/2019 ClienteE André 1,816.00 27,855.00 0.07 78710-129
456 Rondonópolis 1720 3/1/2019 ClienteE Ricardo 1,259.00 29,531.00 0.04 78710-129
456 Rondonópolis 3129 2/1/2019 ClienteA Paulo 2,694.00 31,151.00 0.09 04843-425
327 Rondonópolis 3368 1/1/2019 ClienteB João 4,621.00 34,257.00 0.13 22041-011
327 Cuiabá 4187 3/1/2019 ClienteC André 1,411.00 27,209.00 0.05 78005-020
20 Primavera 1570 4/1/2019 ClienteA Ricardo 3,017.00 26,939.00 0.11 04843-425
456 Primavera 2363 3/1/2019 ClienteB Paulo 3,756.00 27,144.00 0.14 22041-011
456 Cuiabá 2344 4/1/2019 ClienteC João 4,814.00 28,731.00 0.17 78005-020
456 Rondonópolis 3899 2/1/2019 ClienteC André 3,432.00 27,497.00 0.12 78005-020
 SOMASES MÉDIASES CONTSES
Filial Cliente Vendedor SOMA DO VOLUMEMÉDIA DE PREÇO UNITÁRQUANTIDADE DE VENDAS
Rondonópolis ClienteA João 30,074.00 0.155 1
Cuiabá ClienteB André 89,210.00 0.078 3
Primavera ClienteC Ricardo 92,364.00 0.110 3
Primavera ClienteC Paulo 143,552.00 0.147 5
Cuiabá ClienteA João 197,676.00 0.086 7
Rondonópolis ClienteB André 151,696.00 0.087 5
Cuiabá ClienteB Ricardo 86,667.00 0.111 3
Rondonópolis ClienteD Paulo 148,117.00 0.116 5
Cuiabá ClienteD João 89,728.00 0.135 3
Primavera ClienteE André 93,540.00 0.063 3
Rondonópolis ClienteE Ricardo 89,472.00 0.058 3
Rondonópolis ClienteA Paulo 92,289.00 0.119 3
Rondonópolis ClienteB João 92,679.00 0.082 3
Cuiabá ClienteC André 88,571.00 0.057 3
Primavera ClienteA Ricardo 82,857.00 0.084 3
Primavera ClienteB Paulo 87,387.00 0.115 3
Cuiabá ClienteC João 91,789.00 0.144 3
Rondonópolis ClienteC André 91,699.00 0.115 3
Cuiabá ClienteA Ricardo 59,649.00 0.136 2
Rondonópolis ClienteB Paulo 65,875.00 0.066 2
Cuiabá ClienteB João 61,857.00 0.068 2
Primavera ClienteD André 67,431.00 0.087 2
Rondonópolis ClienteD Ricardo 56,056.00 0.128 2
Rondonópolis ClienteE Paulo 62,691.00 0.127 2
Rondonópolis ClienteE João 62,854.00 0.092 2
Cuiabá ClienteA André 61,453.00 0.107 2
Primavera ClienteB Ricardo 53,621.00 0.144 2
Cuiabá ClienteC Ricardo 63,457.00 0.123 2
Rondonópolis ClienteC Paulo 63,997.00 0.081 2
Primavera ClienteB André 56,220.00 0.118 2
Rondonópolis ClienteB Ricardo 60,948.00 0.100 2
Rondonópolis ClienteD João 61,394.00 0.133 2
Cuiabá ClienteE André 65,095.00 0.119 2
Primavera ClienteE Ricardo 58,901.00 0.131 2
Primavera ClienteE Paulo 54,892.00 0.115 2
Rondonópolis ClienteA João 61,825.00 0.103 2