[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1155 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patterson, Riley, S,18058 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Anne,13258 | 5308.26 | 0.00 | 0.00 | 0.00 | 5308.26 |
| Henderson, Chloe,24237 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Mitchell, Jennifer, B,18311 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gao, Alisha,23218 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mitchell, Devin,26819 | 69.46 | 0.00 | 0.00 | 0.00 | 69.46 |
| Russell, Thomas,22338 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Chen, Roger, P,21120 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Russell, Spencer,11302 | 5938.19 | 0.00 | 3578.27 | 2359.92 | 0.00 |
| Chen, Luke,18876 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Peterson, Bryce,18566 | 2379.48 | 0.00 | 0.00 | 0.00 | 2379.48 |
| Jackson, James, L,26302 | 3357.41 | 0.00 | 2049.10 | 0.00 | 1308.31 |
| Liu, Ernest,13511 | 6012.23 | 0.00 | 3578.27 | 0.00 | 2433.96 |
| Yang, Samuel, R,15271 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Van, Arthur, A,12606 | 333.30 | 0.00 | 0.00 | 0.00 | 333.30 |
| Jimenez, Sabrina,17995 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Reed, Charles,14756 | 1588.57 | 0.00 | 699.10 | 0.00 | 889.47 |
| Brown, Taylor, R,26502 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Reed, Alexa, C,23685 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Jones, Samuel, P,15896 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Anderson, Abigail, L,15249 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Washington, Jackson,11978 | 74.98 | 0.00 | 0.00 | 34.99 | 39.99 |
| Wu, Jon,26278 | 29.98 | 0.00 | 0.00 | 29.98 | 0.00 |
| Alonso, Derrick, W,26017 | 89.46 | 0.00 | 0.00 | 89.46 | 0.00 |
| Nara, Tasha,23249 | 49.97 | 0.00 | 0.00 | 49.97 | 0.00 |
| Simmons, Alexandria,17506 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Jiménez, Alfredo,15430 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Anderson, Matthew,15257 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Kelly, Morgan, L,14761 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Parker, Seth, R,18962 | 567.27 | 0.00 | 0.00 | 567.27 | 0.00 |
| Nelson, Chloe, E,12058 | 5936.20 | 0.00 | 3578.27 | 2357.93 | 0.00 |
| Xu, Jon, D,16572 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Hughes, Trevor, L,13552 | 5922.53 | 0.00 | 3578.27 | 0.00 | 2344.26 |
| Scott, Elijah,29035 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Cox, Kaitlyn,13306 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Murphy, Cody,18613 | 2341.97 | 0.00 | 0.00 | 0.00 | 2341.97 |
| Adams, Charles, R,26598 | 33.98 | 0.00 | 0.00 | 33.98 | 0.00 |
| Clark, David, G,24820 | 38.88 | 0.00 | 0.00 | 38.88 | 0.00 |
| James, Abigail,24497 | 71.58 | 0.00 | 0.00 | 71.58 | 0.00 |
| Hall, Jack, P,23050 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Watson, Caitlin, C,19733 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Xu, Todd,28456 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Xu, Susan,17108 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Clark, Charles, K,18656 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Fernandez, Stefanie,25762 | 2517.02 | 0.00 | 0.00 | 0.00 | 2517.02 |
| Andersen, Clarence,12546 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Bennett, Ian, K,15454 | 2746.55 | 0.00 | 2181.56 | 0.00 | 564.99 |
| Garcia, Emily, E,23192 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Wright, Sean, A,18394 | 2297.28 | 0.00 | 0.00 | 0.00 | 2297.28 |
| Sharma, Benjamin, H,25856 | 750.30 | 0.00 | 0.00 | 0.00 | 750.30 |
| Murphy, Melanie, L,21297 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Suarez, Frank,19309 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Xu, Carol, P,13580 | 3707.30 | 0.00 | 0.00 | 0.00 | 3707.30 |
| Mitchell, Richard, T,11881 | 148.40 | 0.00 | 0.00 | 0.00 | 148.40 |
| Suri, Manuel, G,20469 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Diaz, Amanda, S,16966 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Serrano, Renee,15324 | 50.94 | 0.00 | 0.00 | 0.00 | 50.94 |
| Rodriguez, Tina,27888 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Kapoor, Edgar,24134 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, José,12527 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Rivera, Megan, C,15527 | 1622.47 | 0.00 | 0.00 | 782.99 | 839.48 |
| Tangirala, Rakesh, J,20504 | 119.96 | 0.00 | 0.00 | 0.00 | 119.96 |
Generated 2025-12-24 07:17:41.776 UTC