[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Xu, Colin, C,29461 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Powell, Thomas, R,18218 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Saunders, Micheal,17513 | 4260.24 | 3578.27 | 0.00 | 681.97 | 0.00 |
| Diaz, Cheryl, A,11092 | 8110.02 | 3374.99 | 0.00 | 4735.03 | 0.00 |
| Lin, Bianca,11107 | 8171.01 | 3374.99 | 0.00 | 4796.02 | 0.00 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 2410.94 | 2433.04 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 2071.42 | 2349.98 | 2419.06 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 34.99 | 31.27 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 2071.42 | 1249.84 | 2349.98 |
| She, Keith, L,26563 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 2049.10 | 0.00 | 539.99 |
| Gill, Roy,29465 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Suarez, Carolyn, B,18222 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 2181.56 | 1700.99 | 0.00 |
| Chande, Jaclyn, S,18698 | 5314.25 | 3578.27 | 0.00 | 1735.98 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 2181.56 | 1308.47 | 0.00 |
| Beck, Alejandro,11025 | 6576.80 | 3374.99 | 0.00 | 2405.47 | 796.34 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Perez, Kevin, M,25565 | 1239.09 | 699.10 | 0.00 | 0.00 | 539.99 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 2443.35 | 0.00 | 2516.81 |
| Goel, Barbara,12988 | 6915.44 | 0.00 | 2049.10 | 2482.27 | 2384.07 |
Generated 2026-07-22 15:40:56.851 UTC