[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 > TITLE Top 1000 Australian Internet customers for 2020
62 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 2436.97 | 2453.04 |
Liu, Omar, L,12252 | 3938.95 | 0.00 | 3374.99 | 0.00 | 563.96 |
Ms., Simon, Britta,25946 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 638.48 | 0.00 |
Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 2309.97 | 2438.06 |
Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
Gao, Wesley,12346 | 6864.46 | 0.00 | 2071.42 | 2354.98 | 2438.06 |
Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 2341.97 | 2419.06 |
Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
Shen, Jaclyn, A,12575 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
Nath, Grant, A,28947 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
Suarez, Nelson,27355 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
Malhotra, Cynthia,11358 | 5034.78 | 0.00 | 3374.99 | 0.00 | 1659.79 |
Rai, Tracy, K,17079 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
Suarez, Billy, M,17287 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
Munoz, Gary, D,20230 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
Thomas, Christopher, M,20242 | 6068.45 | 0.00 | 3578.27 | 0.00 | 2490.18 |
Butler, Carson, T,12672 | 381.97 | 0.00 | 0.00 | 159.00 | 222.97 |
Diaz, Stacy, L,12340 | 6752.13 | 0.00 | 2049.10 | 2318.96 | 2384.07 |
Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
She, Eugene, L,20998 | 2806.51 | 0.00 | 2181.56 | 624.95 | 0.00 |
Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 2423.95 | 2433.04 |
Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
Arun, Candace, J,21393 | 4925.17 | 0.00 | 2443.35 | 0.00 | 2481.82 |
Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
Serrano, Alfredo,21258 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 2294.99 | 2419.06 |
Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
Hall, Jesse,26133 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
Huang, Alan, A,12671 | 6802.13 | 0.00 | 2049.10 | 2319.99 | 2433.04 |
Henderson, Cassidy,21228 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 2071.42 | 2329.98 | 2438.06 |
Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 2071.42 | 2357.28 | 2384.07 |
Sara, Candace,21380 | 2735.53 | 0.00 | 2181.56 | 553.97 | 0.00 |
Rodriguez, Wyatt, D,21218 | 4661.50 | 0.00 | 2181.56 | 0.00 | 2479.94 |
She, Cedric, R,12580 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
Torres, Meghan, I,21256 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
Hernandez, Alberto, D,25029 | 2272.20 | 0.00 | 0.00 | 1000.44 | 1271.76 |
Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 2319.99 | 2443.55 |
Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
Griffin, Rachel,18255 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 3297.93 | 2319.99 |
Generated 2024-09-19 21:35:17.332 UTC