[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Peterson, Taylor, P,26315 | 2825.43 | 0.00 | 2049.10 | 776.33 | 0.00 |
| Yang, Nathan, D,28674 | 4430.09 | 0.00 | 3578.27 | 851.82 | 0.00 |
| Zeng, Omar,25427 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Rodriguez, Cameron, L,11301 | 131.26 | 0.00 | 0.00 | 0.00 | 131.26 |
| Perry, Xavier, L,23387 | 93.96 | 0.00 | 0.00 | 0.00 | 93.96 |
| Perry, Robert, J,21157 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Thompson, Megan, S,17578 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ortega, Neil, M,15955 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Saunders, Melody, R,14835 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Navarro, Tanya, C,24130 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Andersen, Cassie,14428 | 8321.31 | 0.00 | 3578.27 | 2413.06 | 2329.98 |
| Wu, Darryl, L,11479 | 4970.61 | 0.00 | 0.00 | 4416.64 | 553.97 |
| Zhang, Zachary,27229 | 93.46 | 0.00 | 0.00 | 93.46 | 0.00 |
| Martin, Grace, M,26237 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Peterson, Lauren,19005 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
Generated 2024-09-20 19:20:36.448 UTC