[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Harris, Jeremiah, B,17023 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Gutierrez, Kristi,22638 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Long, Edward, H,12062 | 87.28 | 0.00 | 0.00 | 37.29 | 49.99 |
| Lopez, Holly,26876 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Scott, Kaitlyn, A,12159 | 258.89 | 0.00 | 0.00 | 133.96 | 124.93 |
| Jai, Shaun,24999 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Henderson, Spencer,28224 | 6016.33 | 0.00 | 3578.27 | 0.00 | 2438.06 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Harris, David, C,21467 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Collins, Lucas, T,21921 | 4142.75 | 3578.27 | 0.00 | 0.00 | 564.48 |
| Kumar, Benjamin,22221 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Griffin, Melissa, L,28780 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Ramirez, Cody, M,19148 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Generated 2024-11-10 21:20:38.364 UTC