[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 30 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Sharon, F,22017 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ross, Benjamin,13742 | 2988.32 | 0.00 | 0.00 | 2988.32 | 0.00 |
| Srini, Mayra,22666 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| James, Lauren, T,28815 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Luo, Damien, L,25696 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Coleman, Cassidy,28166 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Mr., Saddow, Peter,24075 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Gutierrez, Wendy,12610 | 101.95 | 0.00 | 0.00 | 0.00 | 101.95 |
| Morris, Arianna, W,14999 | 57.51 | 0.00 | 0.00 | 0.00 | 57.51 |
| Reed, Emma, H,21936 | 99.96 | 0.00 | 0.00 | 0.00 | 99.96 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Patel, Geoffrey, M,24311 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
Generated 2025-12-23 14:31:27.837 UTC