[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 62 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Griffin, Connor, S,12775 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Vance, Holly, S,27795 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Gonzalez, Terrance, B,21833 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Moreno, Julio, C,15953 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Torres, Allison, E,21244 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Jones, Jennifer, L,12467 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Cook, Abigail, J,23874 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Bennett, Emma, E,19880 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ye, Trisha, R,27166 | 827.33 | 0.00 | 0.00 | 0.00 | 827.33 |
| Lewis, Alexandra,24795 | 2507.03 | 0.00 | 0.00 | 0.00 | 2507.03 |
| Nath, Karl, G,13578 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Subram, Frederick, M,11559 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Rodriguez, Erick, D,27209 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Flores, Lucas,12026 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| She, Bethany,12823 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Gray, Nathaniel,17697 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Stephanie, J,25777 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Green, Jackson, S,17475 | 2370.96 | 0.00 | 0.00 | 0.00 | 2370.96 |
| Mitchell, Jack, L,28040 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Moore, Brandon, T,29218 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Sara, Terrance,19255 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Black, Omar,28147 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Bennett, Miguel,26546 | 2847.75 | 0.00 | 0.00 | 2071.42 | 776.33 |
| Chow, Martha,28644 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Hall, Sophia,27726 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Morris, Devin,15875 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Liang, Erica, C,22323 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Edwards, Isabella, A,12881 | 5908.26 | 0.00 | 3578.27 | 0.00 | 2329.99 |
| Rogers, Steven,12940 | 108.46 | 0.00 | 0.00 | 0.00 | 108.46 |
| James, Paige, S,26884 | 1273.83 | 0.00 | 0.00 | 0.00 | 1273.83 |
| He, Laura, W,24692 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
Generated 2025-12-21 02:51:29.925 UTC