[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 930 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Shan, Kelli,17843 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Sharma, Casey, A,12814 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gonzalez, Sergio, S,26357 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Washington, Richard,22074 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Campbell, Richard, A,19892 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gill, Jésus, M,21673 | 638.95 | 0.00 | 0.00 | 0.00 | 638.95 |
| Richardson, Cody,23922 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Ramirez, Jasmine,27237 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Griffin, Robert, S,17534 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shan, Kelvin,24106 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gutierrez, Krista, R,15071 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Jackson, Jonathan, L,14255 | 3379.91 | 0.00 | 0.00 | 1000.44 | 2379.47 |
| Stewart, Isaiah, A,26631 | 2813.77 | 0.00 | 0.00 | 2071.42 | 742.35 |
| Harris, Jasmine,26635 | 2840.42 | 0.00 | 0.00 | 2049.10 | 791.32 |
| Murphy, Jade,15427 | 1574.46 | 0.00 | 0.00 | 782.99 | 791.47 |
| Xu, Kurt, S,16422 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Lal, Kelvin,15082 | 7068.08 | 0.00 | 0.00 | 2181.56 | 4886.52 |
| Anderson, Wyatt, M,14284 | 1769.93 | 0.00 | 0.00 | 1000.44 | 769.49 |
| Thompson, Charles, J,13724 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Ye, Rafael, V,14242 | 3351.40 | 0.00 | 0.00 | 1000.44 | 2350.96 |
| Griffin, Kelly, F,15422 | 1633.94 | 0.00 | 0.00 | 782.99 | 850.95 |
| Morgan, Haley, A,13741 | 2951.05 | 0.00 | 0.00 | 2951.05 | 0.00 |
| Moore, Isabella, B,26632 | 2848.76 | 0.00 | 0.00 | 2071.42 | 777.34 |
| Howard, Richard, D,15428 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Perry, Mya,28739 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Carter, Eduardo,24974 | 100.09 | 0.00 | 0.00 | 0.00 | 100.09 |
| Navarro, Adrienne,23627 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Nichole, C,15934 | 3147.95 | 0.00 | 0.00 | 782.99 | 2364.96 |
Generated 2024-11-11 05:00:58.920 UTC