[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 124 > TITLE Top 1000 Australian Internet customers for 2020
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Madan, Summer, D,12347 | 6839.12 | 0.00 | 2049.10 | 0.00 | 4790.02 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Romero, Raquel, Z,22916 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Goel, Ricardo, T,25961 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Ramos, Naomi, M,23656 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 0.00 | 2049.10 | 3536.35 |
| Coleman, Luis, L,14230 | 5661.90 | 0.00 | 0.00 | 2049.10 | 3612.80 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Tang, Christy, R,23660 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Prasad, Gerald, B,12035 | 81.24 | 0.00 | 0.00 | 64.97 | 16.27 |
| Ortega, Felicia, J,11753 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Raji, Carly, L,23346 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Lal, Rafael, W,28945 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Goel, Derek,17045 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Dominguez, Micheal,26142 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Madan, Jarrod, C,21555 | 4715.49 | 0.00 | 2181.56 | 0.00 | 2533.93 |
| Kapoor, Cynthia,29457 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 0.00 | 4856.99 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Sullivan, Summer, E,21181 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 27.28 | 172.98 |
| Murphy, Grace, J,23655 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Lin, Jorge,27593 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Raman, Ruth, L,21199 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Li, Warren, R,29185 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Wood, Maria,12667 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Ortega, Monique, C,12355 | 6818.11 | 0.00 | 2049.10 | 0.00 | 4769.01 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 2049.10 | 0.00 | 4831.00 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Torres, Jacquelyn, P,27464 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gutierrez, Meghan, E,26021 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Zhou, Jaclyn, C,21179 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Nara, Tara,21194 | 3911.53 | 0.00 | 2181.56 | 0.00 | 1729.97 |
| Perez, Geoffrey, P,21000 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Rubio, Desiree, D,21189 | 4208.31 | 0.00 | 2443.35 | 0.00 | 1764.96 |
| Goel, Bridget,26134 | 1926.45 | 0.00 | 782.99 | 0.00 | 1143.46 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 0.00 | 4843.98 |
| Vazquez, Danny, J,26033 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 2181.56 | 0.00 | 1725.98 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 2443.35 | 0.00 | 2452.34 |
| Chen, Autumn, I,21408 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Huang, Alan, A,12671 | 6802.13 | 0.00 | 2049.10 | 0.00 | 4753.03 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 2071.42 | 0.00 | 4768.04 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Xu, Kelvin, K,21222 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Ma, Roger, V,15130 | 5215.40 | 0.00 | 0.00 | 2049.10 | 3166.30 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Navarro, Jaime, T,27690 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Yang, Valerie, L,27361 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sara, Geoffrey,26188 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 2049.10 | 3568.82 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 101.93 | 7.95 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 0.00 | 831.33 |
| Sharma, Corey, M,17495 | 119.91 | 0.00 | 0.00 | 0.00 | 119.91 |
| Sullivan, Henry, L,20603 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Gray, Brooke, P,26756 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Long, Julian,12034 | 72.25 | 0.00 | 0.00 | 0.00 | 72.25 |
| Nara, Karla, C,25827 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 2071.42 | 0.00 | 4758.05 |
| Vazquez, Roy,26029 | 1930.76 | 0.00 | 782.99 | 0.00 | 1147.77 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 2049.10 | 0.00 | 4719.04 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Kapoor, Jay, F,21956 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 1000.44 | 1147.77 | 0.00 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 2181.56 | 0.00 | 2523.92 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 63.97 | 34.99 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Li, Crystal, L,14325 | 5152.70 | 0.00 | 0.00 | 2049.10 | 3103.60 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 32.27 | 197.98 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 2181.56 | 0.00 | 2460.29 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Sun, Erica, P,26135 | 1967.45 | 0.00 | 782.99 | 0.00 | 1184.46 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 2181.56 | 0.00 | 2481.82 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Navarro, Kellie, I,21873 | 4661.50 | 0.00 | 2181.56 | 0.00 | 2479.94 |
| Romero, Diane, F,21947 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Liang, Glenn,21983 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 0.00 | 782.99 | 1188.46 |
Generated 2025-11-02 17:23:35.532 UTC