[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 841 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Anand, Lacey, J,27150 | 201.28 | 0.00 | 0.00 | 0.00 | 201.28 |
| Lal, Darrell,19953 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Rodriguez, Sergio, D,15239 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Washington, Abigail,23661 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Luo, Christine, J,24159 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Jimenez, Jacquelyn,14304 | 3595.93 | 0.00 | 0.00 | 2049.10 | 1546.83 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Shan, Tasha,15192 | 4384.08 | 0.00 | 0.00 | 2049.10 | 2334.98 |
| Wang, Kelvin, S,15143 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Sara, Donald, M,25114 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Cox, Angel, M,18793 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Anand, Kara,11989 | 8139.53 | 0.00 | 3374.99 | 0.00 | 4764.54 |
| Blanco, Alberto, R,27867 | 2443.55 | 0.00 | 0.00 | 0.00 | 2443.55 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
Generated 2026-01-04 05:40:16.098 UTC