[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lin, Steve, A,14182 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Dominguez, Beth,15459 | 34.92 | 0.00 | 0.00 | 0.00 | 34.92 |
| Carlson, Rebekah,29377 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Sharma, Jack,28826 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Hu, Randy,14976 | 7040.61 | 0.00 | 0.00 | 2181.56 | 4859.05 |
| Smith, Morgan, W,17082 | 3891.54 | 0.00 | 0.00 | 2181.56 | 1709.98 |
| Miller, Jacob,17208 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Campbell, Caleb,11729 | 159.96 | 0.00 | 0.00 | 0.00 | 159.96 |
| Munoz, Lawrence, C,16857 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Adams, Seth, L,16854 | 2342.93 | 0.00 | 0.00 | 0.00 | 2342.93 |
| Dominguez, Alberto, R,26078 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Murphy, Judith,19776 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Blue, Nicole, J,24437 | 2427.04 | 0.00 | 0.00 | 0.00 | 2427.04 |
| Diaz, Jack, H,23372 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Phillips, Eric, W,19712 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Perez, Devin,11937 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Cai, Erica,22816 | 2340.94 | 0.00 | 0.00 | 0.00 | 2340.94 |
| Jenkins, Justin,17693 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cook, Juan,17146 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Cameron, M,13899 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| He, Kelvin, A,22585 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Henderson, Aidan,28171 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Shan, Zachary,24359 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Russell, Margaret,16357 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Phillip, S,20548 | 3131.95 | 0.00 | 0.00 | 782.99 | 2348.96 |
| Smith, Ryan, C,11624 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Lin, Colin,11255 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Butler, Mya,13866 | 4639.51 | 0.00 | 0.00 | 2181.56 | 2457.95 |
| Nara, Keith,21649 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Dominguez, Adrienne, M,23392 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| She, Dale, L,19441 | 1567.46 | 0.00 | 0.00 | 782.99 | 784.47 |
| Rai, Gilbert, B,19384 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Morris, Grace, A,20006 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Phillips, Charles,12174 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Turner, Madeline,23845 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Morgan, Katherine, V,22736 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Zhao, Lisa, C,19859 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| James, Dalton,25084 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Xie, Jaclyn,27123 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Taylor, Anthony, F,22335 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Wood, Antonio,29216 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Kelly, Ariana, R,18096 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Lopez, Gabriel,19216 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Lin, Trisha,12561 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Bailey, Faith, D,25846 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Jenkins, Trevor,11313 | 44.57 | 0.00 | 0.00 | 0.00 | 44.57 |
| Luo, Clarence, M,28158 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Mr., Smith, Rolando, T.,28584 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Kelly, Nathaniel, P,21765 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Wood, Isabel,17377 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Watson, Jessica,23266 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Howard, Katherine,14915 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 |
| Raje, Warren, N,16203 | 6939.87 | 0.00 | 0.00 | 2181.56 | 4758.31 |
| Scott, Angel, E,13245 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Evans, Savannah, K,28112 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Young, Alex, D,25359 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Lopez, Molly, C,17647 | 4122.76 | 0.00 | 0.00 | 1792.78 | 2329.98 |
| Chen, Jenny,27966 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Brett,19079 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| King, Gabriel, V,28122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-24 07:12:01.460 UTC