[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 438 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Blanco, Marc,24908 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Foster, Aidan,26445 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Xu, Margaret, T,22404 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Price, Megan,24907 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Zhou, Alan,16480 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Sai, Abby, L,11101 | 8262.52 | 0.00 | 3399.99 | 2439.99 | 2422.54 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 0.00 | 3361.53 | 0.00 |
| Russell, Noah, M,26447 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Johnsen, Mario, W,26587 | 1920.42 | 0.00 | 0.00 | 782.99 | 1137.43 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 0.00 | 782.99 | 1233.96 |
| Moreno, Jessie, C,22906 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 0.00 | 2049.10 | 4764.02 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Wang, Alan,13622 | 6841.43 | 0.00 | 0.00 | 2071.42 | 4770.01 |
| Yuan, Willie,23421 | 4208.31 | 0.00 | 0.00 | 2443.35 | 1764.96 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 0.00 | 2049.10 | 3672.81 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Turner, Rebecca, W,27699 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 3586.81 | 0.00 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Kumar, Misty, H,25010 | 1540.43 | 0.00 | 0.00 | 1000.44 | 539.99 |
| Sai, Lydia, L,13968 | 5181.70 | 0.00 | 0.00 | 2862.74 | 2318.96 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Guo, Margaret,23431 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Luo, Darrell, J,21187 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 0.00 | 4814.51 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Sun, Leah,17734 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Martinez, Monica, A,14129 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Powell, Alexis, M,23531 | 3337.28 | 0.00 | 0.00 | 3337.28 | 0.00 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
Generated 2025-11-06 19:49:32.932 UTC