[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 311 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Jai, Michele, E,21225 | 4732.86 | 0.00 | 0.00 | 2181.56 | 2551.30 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 0.00 | 2049.10 | 4843.98 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Gutierrez, Jill, N,26024 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Huang, Alan, A,12671 | 6802.13 | 0.00 | 0.00 | 2049.10 | 4753.03 |
| Alvarez, Francis,21552 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Luo, Johnny,21359 | 3032.31 | 0.00 | 0.00 | 2443.35 | 588.96 |
| She, Cedric, R,12580 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Lin, Ronnie, D,21384 | 2921.02 | 0.00 | 0.00 | 2181.56 | 739.46 |
| Ye, Steve,29087 | 810.32 | 0.00 | 0.00 | 0.00 | 810.32 |
| Patel, Virginia, R,11366 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Sara, Donald, M,25114 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Fernandez, Kristina, A,12581 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Madan, Ann,21948 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Rana, Bryant,21878 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 0.00 | 2148.21 | 0.00 |
| Nara, Dawn, M,21891 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Jai, Drew, M,21562 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
Generated 2025-12-23 17:10:48.010 UTC