[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 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 782.99 | 574.98 | 0.00 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 3835.07 | 0.00 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 3563.84 | 0.00 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 2164.91 | 0.00 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 3809.57 | 0.00 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 3464.88 | 2294.99 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 3298.94 | 2366.95 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 3321.26 | 2354.99 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2910.90 | 756.33 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 3298.94 | 2319.99 |
| Kumar, Karl, J,14218 | 5651.88 | 0.00 | 0.00 | 3332.92 | 2318.96 |
| Munoz, Darren,23539 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 3626.82 | 0.00 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Pal, Donna, S,23572 | 3617.83 | 0.00 | 0.00 | 3617.83 | 0.00 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Lopez, Rachael,23425 | 3951.52 | 0.00 | 0.00 | 3951.52 | 0.00 |
| Lal, Franklin, A,14101 | 3679.90 | 0.00 | 0.00 | 2888.58 | 791.32 |
| Beck, April,14302 | 5140.73 | 0.00 | 0.00 | 2071.42 | 3069.31 |
| Ye, Jenny,25036 | 2120.93 | 0.00 | 0.00 | 2120.93 | 0.00 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 2071.42 | 2357.28 | 2384.07 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 126.96 | 0.00 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 831.33 | 0.00 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 16.27 | 30.48 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 2329.99 | 2443.55 |
| Li, Ramon,21248 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 75.97 | 2.29 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Shan, Tony, M,16175 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Morgan, Jared, A,28213 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 49.48 | 197.98 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 63.42 | 0.00 |
| Pal, Nichole, J,26741 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 683.77 | 0.00 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 8.99 | 64.97 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 2453.04 | 0.00 |
| Sai, Evelyn,20415 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 1000.44 | 1149.47 | 0.00 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 84.96 | 0.00 |
| Navarro, Byron,16622 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 44.21 | 24.49 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Sanz, Kellie,16708 | 4406.74 | 3578.27 | 0.00 | 828.47 | 0.00 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 2376.45 | 2419.06 |
| Zhang, Tiffany, R,17318 | 43.97 | 0.00 | 0.00 | 43.97 | 0.00 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 86.93 | 27.28 |
| Yuan, Carl, P,24160 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 103.96 | 63.97 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Blanco, Kari,19627 | 41.75 | 0.00 | 0.00 | 41.75 | 0.00 |
| Navarro, Julio, M,25822 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Sara, Jarrod,20626 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 2350.96 | 2461.55 |
| Russell, Ashley,12000 | 8183.00 | 0.00 | 3399.99 | 2309.97 | 2473.04 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 68.97 | 49.97 |
| Moore, Devin, J,16167 | 102.57 | 0.00 | 0.00 | 0.00 | 102.57 |
| Diaz, Jay,16692 | 31.27 | 0.00 | 0.00 | 24.99 | 6.28 |
| Wilson, Sam,25947 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Perez, Martin,19577 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Ramos, Gloria, A,21365 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 8.99 | 88.98 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 2319.99 | 2419.06 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 32.60 | 24.99 |
| Gomez, Erik, T,29180 | 2452.04 | 0.00 | 0.00 | 2452.04 | 0.00 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 2294.99 | 2384.07 |
| Xu, Randy, S,11969 | 8173.02 | 0.00 | 3399.99 | 2319.99 | 2453.04 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Diaz, Derrick, R,14853 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Guo, Aimee,17075 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
Generated 2026-07-21 21:50:23.938 UTC