[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 63 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ms., Sherwood, Irma, J.,24598 | 4228.31 | 0.00 | 0.00 | 2443.35 | 1784.96 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 24.49 | 153.96 |
| Cooper, Alex, L,27362 | 1407.45 | 0.00 | 0.00 | 782.99 | 624.46 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Shen, Tony,29099 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Zhou, Brent,15434 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Cooper, Cody, A,16028 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 42.93 | 32.60 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Sharon,23329 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morris, Isaac, G,26439 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Hernandez, Ross,14677 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Henderson, Paige, C,17325 | 54.94 | 0.00 | 0.00 | 0.00 | 54.94 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Martin, Arthur, L,28943 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gomez, Marc, J,21880 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Navarro, Daisy,27514 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Shen, Franklin,27144 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
Generated 2025-11-06 13:28:36.534 UTC