[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL 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 | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rodriguez, Carolyn,21002 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Thomas, Madison, M,13389 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Kumar, Nathan,19168 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Li, Austin, B,18110 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Munoz, Jésus, K,13697 | 6485.67 | 0.00 | 3578.27 | 0.00 | 2907.40 |
| Beck, Alicia, L,17248 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Anderson, Matthew,15257 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lopez, Robert, K,22116 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Moreno, Jessie, C,22906 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Black, Russell,18897 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Anderson, Logan, C,15821 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| He, Wesley, I,17849 | 3025.53 | 0.00 | 0.00 | 2181.56 | 843.97 |
| Schmidt, Nancy,11403 | 5033.14 | 0.00 | 0.00 | 4469.37 | 563.77 |
| Alvarez, Dana,15067 | 2803.52 | 0.00 | 0.00 | 2181.56 | 621.96 |
| Shan, Michele,27323 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Gomez, Orlando,29353 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Peterson, Kaylee,23293 | 152.28 | 0.00 | 0.00 | 0.00 | 152.28 |
| Reed, Emma, H,21936 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| Chande, Mindy, V,27472 | 1345.95 | 0.00 | 0.00 | 782.99 | 562.96 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Turner, Haley, M,11804 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 |
| Lopez, Madeline, G,12044 | 105.95 | 0.00 | 0.00 | 0.00 | 105.95 |
| Morgan, Chase, D,11791 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Barnes, Seth,21603 | 567.76 | 0.00 | 0.00 | 567.76 | 0.00 |
| She, Peter, D,20046 | 691.91 | 0.00 | 0.00 | 0.00 | 691.91 |
| Rogers, Victoria,15658 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Raji, Kelvin, S,28885 | 4470.89 | 0.00 | 0.00 | 2071.42 | 2399.47 |
| Shen, Johnny,19330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Becker, Kate,16447 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Xie, Tasha, D,24696 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Yang, Heather,18275 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Ferrier, Marc,12509 | 82.85 | 0.00 | 0.00 | 12.98 | 69.87 |
| Suarez, Jaime, L,15056 | 6749.05 | 0.00 | 3578.27 | 0.00 | 3170.78 |
| Rana, Bruce, E,21125 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Fernandez, Ann, M,12931 | 155.94 | 0.00 | 0.00 | 8.99 | 146.95 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 34.99 | 599.85 |
| Martin, Carolyn, M,12652 | 182.94 | 0.00 | 0.00 | 0.00 | 182.94 |
| Cooper, Zoe, L,27751 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Luo, Barbara,27978 | 29.48 | 0.00 | 0.00 | 29.48 | 0.00 |
| Henderson, Edward,27747 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Torres, Tabitha,17629 | 4173.32 | 0.00 | 0.00 | 4173.32 | 0.00 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Shan, Karla,19493 | 3515.37 | 0.00 | 0.00 | 3515.37 | 0.00 |
| Brooks, Nicole,26467 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Russell, Samantha,11211 | 793.55 | 0.00 | 0.00 | 118.46 | 675.09 |
| Powell, Ryan, K,29014 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Adams, Charles, R,26598 | 33.98 | 0.00 | 0.00 | 33.98 | 0.00 |
| Sai, George, T,23549 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Ortega, Krista,28548 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Clark, David, G,24820 | 38.88 | 0.00 | 0.00 | 38.88 | 0.00 |
| Clark, Samantha,26573 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Sara, George,24247 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Evans, Jack,17489 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Watson, Eduardo, M,23452 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Prasad, Tina, A,21869 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ma, Jamie, P,29446 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Stewart, Chase,12810 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Blanco, Julio, J,17678 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
Generated 2025-11-03 22:24:41.121 UTC