[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 62 > TITLE Top 1000 Australian Internet customers for 2020
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ruiz, Ricky,20718 | 3283.43 | 0.00 | 782.99 | 0.00 | 2500.44 |
| Blanco, Rebekah,18149 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Perez, Jack,19455 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Liang, Wesley, A,12123 | 5837.84 | 0.00 | 2049.10 | 2351.96 | 1436.78 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Beck, Damien, E,23989 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 3309.24 | 2357.28 |
| Li, Caleb,22640 | 1149.47 | 0.00 | 0.00 | 1149.47 | 0.00 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 0.00 | 110.94 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Latasha, L,22540 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Nara, Gilbert, O,28425 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rodriguez, Bryant, R,29360 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Patel, Ebony,25531 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Howard, Angel, A,23223 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Zhang, Benjamin, F,12593 | 42.97 | 0.00 | 0.00 | 8.99 | 33.98 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Li, Darryl, T,24549 | 2514.93 | 0.00 | 0.00 | 0.00 | 2514.93 |
| Ma, Leah, H,14553 | 147.95 | 0.00 | 0.00 | 78.98 | 68.97 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Andersen, Nichole,12653 | 6860.09 | 0.00 | 0.00 | 2049.10 | 4810.99 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Munoz, Lori, M,22639 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Sharma, Alicia, L,19440 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 2350.96 | 1438.80 |
| Suri, Brenda, D,22643 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Price, Wyatt,12336 | 78.98 | 0.00 | 0.00 | 28.99 | 49.99 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 2354.98 | 2413.06 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Luo, Cassie,16452 | 3071.01 | 0.00 | 2181.56 | 0.00 | 889.45 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Vance, Joe, L,28877 | 12.98 | 0.00 | 0.00 | 12.98 | 0.00 |
| Bailey, Xavier,12305 | 4940.39 | 0.00 | 0.00 | 4391.41 | 548.98 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 74.98 | 77.96 |
| Martin, Dalton, J,12505 | 36.59 | 0.00 | 0.00 | 36.59 | 0.00 |
| Xu, Mario,26411 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Gray, Jessica,19479 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 2533.93 | 0.00 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| She, Carl, A,12317 | 6823.42 | 0.00 | 0.00 | 6823.42 | 0.00 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 4.99 | 39.98 |
| Mehta, Douglas,19258 | 1574.42 | 0.00 | 1000.44 | 0.00 | 573.98 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Perry, Sydney, C,14963 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 3331.92 | 2388.45 |
| Carter, Miguel,13776 | 70.57 | 0.00 | 0.00 | 70.57 | 0.00 |
Generated 2025-11-03 01:19:22.785 UTC