[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 310 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Martin, Ruben,22400 | 2737.82 | 0.00 | 0.00 | 2181.56 | 556.26 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Price, Deb,24502 | 3623.32 | 0.00 | 0.00 | 2443.35 | 1179.97 |
| Diaz, Jay,16692 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Ramos, Mathew, E,28961 | 2478.04 | 0.00 | 0.00 | 0.00 | 2478.04 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Huang, Barbara,26442 | 1919.75 | 0.00 | 0.00 | 782.99 | 1136.76 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Sanchez, Nancy, L,22207 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Edwards, Kaylee, M,22851 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| Xu, Alejandro, R,26585 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Torres, Diane, M,25211 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Raji, Terry,15597 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Zhao, Rosa, A,19672 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rai, Colleen,28933 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Hu, Amy,14320 | 261.95 | 0.00 | 0.00 | 0.00 | 261.95 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Jackson, Joshua,17235 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Vazquez, Shannon,26035 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Price, Vanessa, A,23569 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Muñoz, Jaime, C,24506 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Goel, Tommy,22909 | 3980.52 | 0.00 | 0.00 | 2181.56 | 1798.96 |
| She, Brittney, M,22942 | 3971.53 | 0.00 | 0.00 | 2181.56 | 1789.97 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Ortega, Eddie,22908 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 0.00 | 782.99 | 613.45 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Kovar, Nancy, F,26568 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Morgan, Sara,13134 | 5648.92 | 0.00 | 0.00 | 2049.10 | 3599.82 |
| Goldstein, Brendan,13518 | 2638.36 | 0.00 | 0.00 | 2049.10 | 589.26 |
| Shen, Karl, M,15151 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Pal, Clayton,27721 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 2049.10 | 3569.83 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
Generated 2025-12-24 06:04:10.731 UTC