[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Evans, Fernando, W,18497 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Shan, Kevin,18386 | 2309.97 | 0.00 | 0.00 | 0.00 | 2309.97 |
| Yuan, Alisha, M,27013 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Davis, David,22159 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Melody,18134 | 5732.47 | 0.00 | 1000.44 | 0.00 | 4732.03 |
| Alexander, Stephanie,24950 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Morgan, Savannah, P,21430 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Gray, Haley,15842 | 3152.96 | 0.00 | 0.00 | 782.99 | 2369.97 |
| Walker, Ashley, D,15961 | 3127.25 | 0.00 | 0.00 | 782.99 | 2344.26 |
| Patel, Kristopher,15976 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Ye, Jorge, R,16426 | 5768.36 | 0.00 | 0.00 | 2181.56 | 3586.80 |
| Kelly, Abigail, A,26609 | 4509.48 | 0.00 | 0.00 | 2071.42 | 2438.06 |
| Lal, Austin, M,23066 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Gao, Glenn,20108 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Zhao, Roger,22322 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Vazquez, Julio, E,14969 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Navarro, Joe, A,20140 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Patterson, Julian, D,11840 | 87.28 | 0.00 | 0.00 | 0.00 | 87.28 |
| Thomas, Marcus, Z,29268 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Kelly, Stephanie, L,25102 | 71.58 | 0.00 | 0.00 | 71.58 | 0.00 |
| Lewis, Michael, R,14782 | 66.96 | 0.00 | 0.00 | 66.96 | 0.00 |
| Guo, Jessie, J,12793 | 120.47 | 0.00 | 0.00 | 120.47 | 0.00 |
| Perry, Samantha, F,24776 | 91.58 | 0.00 | 0.00 | 91.58 | 0.00 |
| Gill, Andy,22673 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Shan, Maurice, M,11433 | 12909.67 | 0.00 | 0.00 | 6934.48 | 5975.19 |
| Stewart, Angela,13301 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Taylor, Ethan,22555 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Richardson, Amanda,15888 | 3178.95 | 0.00 | 0.00 | 782.99 | 2395.96 |
| Arun, Phillip, A,27133 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Deng, Cristina, J,14972 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Thomas, Joshua, A,18643 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Diaz, Justin,18427 | 2334.46 | 0.00 | 0.00 | 0.00 | 2334.46 |
| Martinez, Eduardo, W,24234 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Sai, Kristina,26957 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Liu, Rosa,23612 | 2395.96 | 0.00 | 0.00 | 0.00 | 2395.96 |
| Nath, Bridget, C,19446 | 1560.43 | 0.00 | 0.00 | 782.99 | 777.44 |
| Turner, Jordan, B,13420 | 4798.33 | 0.00 | 2443.35 | 0.00 | 2354.98 |
| Clark, Megan,20093 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Flores, Caroline,19155 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Young, Jesse, E,18676 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rodriguez, Kaitlyn,21159 | 74.46 | 0.00 | 0.00 | 74.46 | 0.00 |
| Watson, Sara, C,14921 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Allen, Haley, T,17640 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Alexander, Haley,11837 | 5923.23 | 0.00 | 3578.27 | 2344.96 | 0.00 |
| Martin, Jarred,27777 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Miller, Wyatt, M,26703 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Murphy, Isabella,22645 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gray, Ariana, D,11425 | 10528.63 | 0.00 | 0.00 | 4551.06 | 5977.57 |
| Phillips, Carlos, D,27750 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Bell, Jeremy, F,26525 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Lewis, Megan, L,24524 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Cooper, Xavier,20185 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Long, Jessica, R,16808 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Flores, Amanda,22981 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Cook, Dalton, E,18851 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Navarro, Diane,14698 | 60.95 | 0.00 | 0.00 | 0.00 | 60.95 |
| McDonald, Cesar, C,12821 | 124.94 | 0.00 | 0.00 | 0.00 | 124.94 |
| Parker, Devin,11684 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Goel, Shaun, L,22417 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Long, Jocelyn,12886 | 5965.22 | 0.00 | 3578.27 | 0.00 | 2386.95 |
| West, Elizabeth,26604 | 4442.16 | 0.00 | 0.00 | 2049.10 | 2393.06 |
| Young, Madeline,18121 | 1793.47 | 0.00 | 0.00 | 0.00 | 1793.47 |
Generated 2025-11-07 03:16:00.381 UTC