[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 71 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Sandberg, Kristine,12241 | 3989.46 | 0.00 | 3399.99 | 0.00 | 589.47 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Rodriguez, Allen, L,17732 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Vance, Kristopher, C,20407 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Ashley, E,18215 | 150.97 | 0.00 | 0.00 | 0.00 | 150.97 |
| Sanz, Tabitha,17496 | 110.96 | 0.00 | 0.00 | 0.00 | 110.96 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Jai, Carly,22986 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Rodriguez, Carla, V,21230 | 4171.62 | 0.00 | 0.00 | 2443.35 | 1728.27 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| He, Colin, B,14300 | 5322.73 | 0.00 | 0.00 | 2071.42 | 3251.31 |
| Chander, Edwin, T,17370 | 4742.74 | 0.00 | 3578.27 | 0.00 | 1164.47 |
| She, Tamara, M,14224 | 5621.22 | 0.00 | 0.00 | 2049.10 | 3572.12 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
Generated 2025-12-23 14:30:57.926 UTC