[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Butler, Brittany,28641 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Bailey, Charles, C,28330 | 10.24 | 0.00 | 0.00 | 0.00 | 10.24 |
| Campbell, Madeline,12898 | 5958.74 | 0.00 | 3578.27 | 0.00 | 2380.47 |
| Butler, Devin, M,17153 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Ross, Hunter,24722 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Powell, Anna, J,23680 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Jai, Shaun,24999 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Fernandez, Cory, P,13409 | 108.95 | 0.00 | 0.00 | 0.00 | 108.95 |
| Washington, Sarah, C,13855 | 3095.52 | 0.00 | 0.00 | 2181.56 | 913.96 |
| Allen, Blake,17382 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gray, Alexandra,25929 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Wright, Katherine,25997 | 4623.83 | 0.00 | 3399.99 | 0.00 | 1223.84 |
| Pal, Kurt, B,11393 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zheng, Martha, L,13796 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Manuel,13839 | 3242.83 | 0.00 | 2443.35 | 0.00 | 799.48 |
| Murphy, Nicole, D,11927 | 51.94 | 0.00 | 0.00 | 0.00 | 51.94 |
| Sharma, Jordan, R,17393 | 2404.91 | 0.00 | 0.00 | 0.00 | 2404.91 |
| Andersen, Yolanda,21954 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Vazquez, Larry, M,12655 | 10899.62 | 0.00 | 3578.27 | 0.00 | 7321.35 |
| Diaz, Albert, A,12436 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Arun, Meredith, H,26963 | 1237.82 | 0.00 | 0.00 | 0.00 | 1237.82 |
| Hughes, Jack, S,16677 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perry, Angela,11623 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Rubio, Audrey, L,15482 | 3124.45 | 0.00 | 0.00 | 782.99 | 2341.46 |
| Smith, Emily, A,17692 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Alonso, Ruben, A,16881 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Ross, Justin, J,14076 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Coleman, Morgan,23956 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
Generated 2025-12-21 21:27:15.846 UTC