[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 16 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Brad, C,18267 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Xie, Casey,21217 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Madan, Ann,21948 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Martinez, Kari,19609 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Diaz, Roberto, A,22202 | 4671.74 | 0.00 | 0.00 | 2181.56 | 2490.18 |
| Jimenez, Felicia, L,11075 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| White, Ashley, D,21887 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rana, Jermaine, S,28927 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Martin, Alyssa,19587 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Mehta, Gerald,20234 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gutierrez, Victor, J,27357 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xu, Rafael, A,21885 | 4641.85 | 0.00 | 0.00 | 2181.56 | 2460.29 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Xie, Chad, A,26155 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Shan, Colin,25921 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
Generated 2025-12-21 07:52:29.059 UTC