[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ye, Willie,22963 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Sun, Micah,24887 | 2218.90 | 0.00 | 0.00 | 1000.44 | 1218.46 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Rai, Tracy, K,17079 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 0.00 | 2520.83 |
| Zhang, Amy,18307 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Wilson, Zachary,25558 | 1307.06 | 0.00 | 699.10 | 0.00 | 607.96 |
| Black, Mindy, W,18696 | 6149.57 | 0.00 | 3578.27 | 0.00 | 2571.30 |
| Vazquez, Jerome,23116 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Raje, Alison, J,12345 | 64.71 | 0.00 | 0.00 | 0.00 | 64.71 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Guo, Don,18742 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Anand, Chad,24484 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Coleman, Ethan, G,16693 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Lu, Ramon, B,16738 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Zhao, Rosa, A,19672 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Munoz, Jacquelyn,29115 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 0.00 | 214.25 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Suarez, Kristi, D,23099 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Romero, Paula, B,16691 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Yuan, Chad, C,21173 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Moreno, Bruce, F,26652 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 0.00 | 4688.05 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Martinez, Tyler, T,28201 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Prasad, Darren,12372 | 99.03 | 0.00 | 0.00 | 0.00 | 99.03 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
Generated 2025-12-21 09:31:00.407 UTC