[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 30 < SKIP 1437 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 0.00 | 782.99 | 613.45 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhao, Marshall, C,22033 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gonzalez, Deanna, S,15204 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Suri, Kari,25266 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Williams, Wyatt, E,19614 | 6217.21 | 0.00 | 3578.27 | 0.00 | 2638.94 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Lal, Shawna,17924 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Malhotra, Ruben, M,17074 | 90.25 | 0.00 | 0.00 | 58.98 | 31.27 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Munoz, Alfredo, C,23314 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Wu, Amy,19790 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| He, Louis, E,21211 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Torres, Carolyn,15261 | 70.74 | 0.00 | 0.00 | 0.00 | 70.74 |
| Lu, Alan,19761 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Luo, Priscilla, R,17907 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 0.00 | 1793.47 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Diaz, Gary,27482 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Hill, Mackenzie,19576 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Goel, Dale, M,20416 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gao, Bianca, C,13112 | 5717.89 | 0.00 | 0.00 | 2049.10 | 3668.79 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Peterson, Lucas,17298 | 174.45 | 0.00 | 0.00 | 0.00 | 174.45 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Perry, Madison, R,23308 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Phillip,29308 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Moore, Thomas,14010 | 3861.39 | 0.00 | 0.00 | 2071.42 | 1789.97 |
| Lu, Susan, C,12357 | 93.45 | 0.00 | 0.00 | 0.00 | 93.45 |
| Sun, Franklin,19615 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Guo, Krystal, S,17381 | 188.93 | 0.00 | 0.00 | 0.00 | 188.93 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Lal, Terrence,12369 | 94.23 | 0.00 | 0.00 | 0.00 | 94.23 |
| Diaz, Josue,15207 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Hu, Valerie, M,15044 | 3803.56 | 0.00 | 0.00 | 2049.10 | 1754.46 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
Generated 2025-12-23 14:19:15.497 UTC