[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Suri, Patricia, E,15436 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Huang, Colleen, S,21379 | 2992.33 | 0.00 | 0.00 | 2443.35 | 548.98 |
| Chander, Kelvin, E,27879 | 1313.34 | 0.00 | 0.00 | 0.00 | 1313.34 |
| Chander, Russell, E,29067 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alonso, Sheila,25054 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Subram, Martin, S,19590 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Luo, Nina,27495 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Weber, Jarrod, M,14859 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Luo, Colleen, E,15208 | 2951.56 | 0.00 | 0.00 | 2049.10 | 902.46 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Anand, Alison, J,24009 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Moreno, Latasha, R,18735 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Andersen, Lacey,19600 | 94.46 | 0.00 | 0.00 | 0.00 | 94.46 |
| Martinez, Frederick,11991 | 8128.02 | 0.00 | 3374.99 | 0.00 | 4753.03 |
| Goel, Christine, A,21231 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Gill, Gary, B,25108 | 2199.41 | 0.00 | 0.00 | 1000.44 | 1198.97 |
| Arthur, Tammy, L,21363 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Ye, Marshall, R,26559 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Hu, Amy,14320 | 261.95 | 0.00 | 0.00 | 0.00 | 261.95 |
| Washington, Abigail,23661 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Hu, Krystal, D,13012 | 7017.44 | 0.00 | 0.00 | 2071.42 | 4946.02 |
| Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gill, Erika, A,18202 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Yuan, Ricardo,16674 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Zhao, Kelvin,25135 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Watson, Anna,20238 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Zhu, Vincent, E,24899 | 105.45 | 0.00 | 0.00 | 0.00 | 105.45 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Wood, Fernando, K,24253 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 0.00 | 227.96 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Nath, Keith,19617 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Madan, Stanley,19602 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Wayne, P,23647 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hill, Aaron,25818 | 35.96 | 0.00 | 0.00 | 0.00 | 35.96 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 0.00 | 4856.99 |
Generated 2025-12-21 22:05:11.961 UTC