[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 43 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hughes, Devin, P,22861 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| King, Jenna, R,20015 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Shan, Ricardo,24210 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Cox, Bryan,27449 | 4482.14 | 0.00 | 0.00 | 2049.10 | 2433.04 |
| Robinson, Emma, C,16844 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Clark, Christian, H,13695 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Munoz, Dwayne, F,24091 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Evans, Kaitlyn,13452 | 4800.30 | 0.00 | 0.00 | 2443.35 | 2356.95 |
| Rogers, Erin,12364 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Jenkins, Jack,23891 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Luo, Jenny, L,19474 | 1589.75 | 0.00 | 0.00 | 782.99 | 806.76 |
| Malhotra, Virginia,23758 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Zhu, Micah, V,11576 | 4486.41 | 0.00 | 0.00 | 2071.42 | 2414.99 |
| Sanders, Xavier,16721 | 106.96 | 0.00 | 0.00 | 0.00 | 106.96 |
| Smith, Matthew, J,28830 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Watson, Grace, D,15318 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Kristin, G,17711 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Young, Katelyn, W,23700 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Carlson, Danny,27859 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Xie, Tony, R,28532 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Howard, Devin, S,24949 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Sai, Nancy, B,23440 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Dominguez, Kari, S,17789 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Hernandez, Jerome,16270 | 2771.52 | 0.00 | 0.00 | 2181.56 | 589.96 |
| Martinez, Carmen, E,14169 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Nelson, Samuel,21246 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Andersen, Cassie,14428 | 8321.31 | 0.00 | 3578.27 | 0.00 | 4743.04 |
| Lee, Sarah, M,23810 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
Generated 2025-12-22 02:10:46.978 UTC