[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 60 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alexander, Chloe,15817 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Jai, David,23483 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Hughes, Jonathan,22282 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Suarez, Frank,19309 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Powell, Hannah,24631 | 146.06 | 0.00 | 0.00 | 0.00 | 146.06 |
| Allen, Andrea, K,18798 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Gill, Andy,22673 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Torres, Olivia,26014 | 4713.33 | 0.00 | 3399.99 | 0.00 | 1313.34 |
| Brooks, Timothy,17600 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Zhou, Randy, J,21825 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, Emma,21744 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| He, Tamara,25742 | 2462.03 | 0.00 | 0.00 | 0.00 | 2462.03 |
| Schmidt, Meagan,18183 | 3343.36 | 0.00 | 0.00 | 1000.44 | 2342.92 |
| Richardson, Hailey, W,15873 | 3123.93 | 0.00 | 0.00 | 782.99 | 2340.94 |
| Parker, Jack,17270 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
Generated 2025-12-21 15:24:51.203 UTC