[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 972 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Beck, Christy, A,19366 | 1617.46 | 0.00 | 0.00 | 782.99 | 834.47 |
| Perry, Ethan,26088 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Davis, Jose,24981 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Raji, Alicia,18404 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jenkins, Olivia,19166 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carlson, Andy,23445 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Nelson, Courtney, T,14746 | 1588.57 | 0.00 | 699.10 | 0.00 | 889.47 |
| Peterson, Natalie, M,15840 | 3080.27 | 0.00 | 0.00 | 782.99 | 2297.28 |
| Morgan, Gabrielle,15980 | 3077.98 | 0.00 | 0.00 | 782.99 | 2294.99 |
| Alexander, Jose, J,26627 | 2791.45 | 0.00 | 0.00 | 2049.10 | 742.35 |
| Wu, Cara,23142 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Watson, Patrick, H,18049 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Walker, Nicole,11860 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Brandi,16424 | 5738.38 | 0.00 | 0.00 | 2181.56 | 3556.82 |
| Morgan, Michelle, C,23217 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Butler, Emma, S,20394 | 1158.46 | 0.00 | 0.00 | 0.00 | 1158.46 |
| Cook, Nathaniel, G,17567 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Sharma, Russell, A,15637 | 6999.57 | 0.00 | 0.00 | 2181.56 | 4818.01 |
| Moore, Blake, S,11667 | 91.28 | 0.00 | 0.00 | 0.00 | 91.28 |
| Bennett, Alexandra,24961 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Harris, Nicole, M,20349 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Torres, Alex, L,18512 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Edwards, Gabrielle,28297 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Barnes, Amanda, N,20744 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Hernandez, Sophia,18980 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Bennett, Aidan,18998 | 1784.96 | 0.00 | 0.00 | 0.00 | 1784.96 |
| Griffin, Alexis, S,25376 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Zhao, Louis,16806 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
Generated 2024-11-11 03:32:42.264 UTC