[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Jacquelyn,21860 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chen, Colleen, C,20321 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alexander, Alexandria,26333 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Blue, Rachel,20359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lewis, Megan, L,24524 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Suarez, Byron, R,16403 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Butler, Kevin, R,14450 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Nara, Christine,11878 | 82.93 | 0.00 | 0.00 | 0.00 | 82.93 |
| Luo, Kristin, G,17711 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Henderson, Samantha, M,25274 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Scott, Morgan, D,22163 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Long, Samantha,11128 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Shan, James,23495 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Simmons, Jennifer,11262 | 116.26 | 0.00 | 0.00 | 0.00 | 116.26 |
| Hughes, Emma, A,15012 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Cory, E,12501 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Nelson, Morgan,20501 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Gao, Clarence, H,12631 | 10799.52 | 0.00 | 3578.27 | 0.00 | 7221.25 |
| Simmons, Paige,24654 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Yuan, Nicolas, J,19756 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Bryant, Blake, C,15202 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Baker, Gabrielle, D,14618 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cai, Laura, L,21113 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Shen, April, J,28547 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Sanders, Carlos,20127 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chapman, Phillip,23240 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Morgan, Xavier,22883 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Hayes, Vanessa,16471 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| James, Destiny, A,11788 | 255.27 | 0.00 | 0.00 | 0.00 | 255.27 |
| Moreno, Rodney, I,16984 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
Generated 2025-12-23 07:15:27.269 UTC