[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 15 SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Raman, Allen, R,25129 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Malhotra, Emmanuel,18332 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 0.00 | 2482.23 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Jimenez, Latasha, E,13121 | 121.25 | 0.00 | 0.00 | 0.00 | 121.25 |
| Lin, Suzanne,29287 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Xie, Jaime,25823 | 1887.56 | 0.00 | 699.10 | 0.00 | 1188.46 |
| Gray, Faith,22914 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chander, Omar, W,17241 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Powell, Grace, B,29194 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Jimenez, Teresa, L,24372 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Hall, Haley,27489 | 1383.45 | 0.00 | 0.00 | 782.99 | 600.46 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Shan, Jaime,22020 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Navarro, Javier,14131 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Pal, Omar,27714 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lopez, Clifford, E,27709 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Lopez, Isaac,27692 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Jiménez, Beth, H,11120 | 8242.49 | 0.00 | 3374.99 | 0.00 | 4867.50 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Price, Vanessa, A,23569 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Lee, L,27694 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Yuan, Derek, L,27589 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Rodriguez, Evelyn,13117 | 6831.42 | 0.00 | 0.00 | 2049.10 | 4782.32 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Navarro, Kathleen, J,19269 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| She, Clarence, L,24901 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 0.00 | 928.49 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Guo, Aimee,17075 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Xu, Wesley, K,29182 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Kapoor, Cynthia,29457 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Martin, Casey, J,22962 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Rodriguez, Carolyn,21002 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Hayes, Edward,15796 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
Generated 2025-12-21 20:46:23.956 UTC