[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patterson, Elizabeth, E,13322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Campbell, Eric,13354 | 4498.53 | 0.00 | 0.00 | 2181.56 | 2316.97 |
| Ross, Marcus, F,26508 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Griffin, Carson, L,21241 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Simmons, Kyle, J,18599 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Howard, Juan, K,18180 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Moreno, Ebony, J,16409 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Powell, Edward, S,29112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gray, Gabrielle, E,15560 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Terrance, G,29438 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Flores, Blake,11206 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Rivera, Angel,13316 | 4576.53 | 0.00 | 0.00 | 2181.56 | 2394.97 |
| Yang, Cameron,12117 | 159.99 | 0.00 | 0.00 | 0.00 | 159.99 |
| Anand, Latoya, D,28347 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Green, Julia,18874 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Roberts, Jonathan,18417 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harris, Logan, C,24945 | 152.60 | 0.00 | 0.00 | 0.00 | 152.60 |
| Hughes, Gabriel, L,22286 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Brown, John,20637 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Shan, Samuel, E,21455 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Watson, Danielle,18572 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Murphy, Patrick, M,14334 | 1848.91 | 0.00 | 0.00 | 1000.44 | 848.47 |
| Gill, Janet, B,25192 | 2480.99 | 0.00 | 0.00 | 0.00 | 2480.99 |
| Parker, Luis, S,17768 | 3907.04 | 0.00 | 0.00 | 2181.56 | 1725.48 |
| Pal, Edwin, M,13573 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Martinez, Kaitlyn, S,20072 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Vazquez, Tanya,27167 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Hall, Aaron, K,27246 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Simmons, Melanie, T,24449 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Mr., Lee, Blake, D,24677 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| James, Cole, S,20411 | 69.47 | 0.00 | 0.00 | 0.00 | 69.47 |
| Edwards, Jordan, R,16107 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Long, Alexandria, E,11714 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Jackson, Jennifer,13403 | 4578.52 | 0.00 | 0.00 | 2181.56 | 2396.96 |
| Morris, Bryan, D,25162 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Chen, Nathan, D,25175 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Srini, Dominic, M,14737 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Alonso, Lawrence, S,12323 | 7258.63 | 0.00 | 0.00 | 0.00 | 7258.63 |
| Zhao, Brent,22500 | 2481.82 | 0.00 | 0.00 | 0.00 | 2481.82 |
| Johnson, Jennifer, F,24355 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Harris, Fernando, R,17876 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Vazquez, Dwayne, C,12493 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lopez, Isabella,12957 | 43.99 | 0.00 | 0.00 | 0.00 | 43.99 |
| Hernandez, Gabriella,16375 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Patterson, Jason,20385 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Hughes, Chloe, J,12755 | 5998.72 | 0.00 | 3578.27 | 0.00 | 2420.45 |
| Coleman, Miranda,17620 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Jordan, Chelsea,24209 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hu, Suzanne,15004 | 3073.31 | 0.00 | 0.00 | 2443.35 | 629.96 |
| Chen, Dawn, C,16580 | 5429.76 | 0.00 | 0.00 | 2443.35 | 2986.41 |
| Wang, Todd,15676 | 7224.68 | 0.00 | 0.00 | 2443.35 | 4781.33 |
| Gonzales, Eduardo, C,19665 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Phillips, Logan, A,13212 | 4564.49 | 0.00 | 2181.56 | 0.00 | 2382.93 |
| Martin, Kristi, C,21029 | 1934.75 | 0.00 | 0.00 | 782.99 | 1151.76 |
| Huang, Claudia, M,23990 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Russell, Angela,12049 | 171.44 | 0.00 | 0.00 | 0.00 | 171.44 |
| Lal, Jackson, E,23206 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Muñoz, Jose, R,26982 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Wilson, Megan,12937 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Coleman, Ana, L,21335 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Reed, Eduardo,27038 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Angelica,11639 | 127.26 | 0.00 | 0.00 | 0.00 | 127.26 |
| Williams, Katherine, K,11972 | 65.25 | 0.00 | 0.00 | 0.00 | 65.25 |
| Martinez, Hunter, K,13192 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Scott, Marcus, G,20700 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Prasad, Carla,14524 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Chen, Brittney, C,20379 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Hughes, Alexandria, W,27625 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Long, Ethan, H,23834 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Simmons, Alexis,23849 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Malhotra, Don, S,25472 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Suarez, Armando,28430 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Cai, Crystal, L,24062 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Mr., Simpson, Marty, E.,26292 | 4456.14 | 0.00 | 0.00 | 2049.10 | 2407.04 |
| Gray, Bryan, J,20650 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Thompson, Logan, T,26522 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Scott, Caleb,24936 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Allen, Jordan,26574 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Mitchell, Carlos,20770 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Miller, Jessica,13200 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Davis, Grace,12127 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Simmons, Ethan,13210 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Gonzales, Taylor, M,21590 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Griffin, Jordyn, N,13757 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Mr., Sánchez, Ken,13512 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bryant, Aidan, R,15364 | 3183.94 | 0.00 | 0.00 | 782.99 | 2400.95 |
| Perry, Tristan, G,25866 | 4603.82 | 3374.99 | 0.00 | 0.00 | 1228.83 |
| Peterson, Isaac, J,26114 | 5853.03 | 0.00 | 3399.99 | 0.00 | 2453.04 |
| Cooper, Carlos, S,17608 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Subram, Harold, D,23903 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Diaz, Adam, H,23982 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Lewis, Cindy, C,16206 | 7203.35 | 0.00 | 0.00 | 2443.35 | 4760.00 |
| Rivera, Marcus, M,14147 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Li, Damien, L,20887 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Shan, April, L,11566 | 1006.83 | 0.00 | 0.00 | 250.25 | 756.58 |
| Ye, Barbara, A,27805 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Davis, Destiny,11747 | 115.96 | 0.00 | 0.00 | 0.00 | 115.96 |
| Lal, Logan, L,25255 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Baker, Dalton, B,23207 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Chande, Lindsey,20094 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Adams, Jesse, M,17172 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Xie, Tamara,28384 | 67.59 | 0.00 | 0.00 | 0.00 | 67.59 |
| Lee, Eduardo,11697 | 152.96 | 0.00 | 0.00 | 0.00 | 152.96 |
| Robinson, Katherine,15483 | 3120.26 | 0.00 | 0.00 | 782.99 | 2337.27 |
| Thomas, Morgan,12771 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Wright, Mackenzie, K,12412 | 258.48 | 0.00 | 0.00 | 0.00 | 258.48 |
| Rai, Peter,19990 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gonzalez, Kevin,27668 | 6006.56 | 3578.27 | 0.00 | 0.00 | 2428.29 |
| Lopez, Thomas, A,18654 | 1775.97 | 0.00 | 0.00 | 0.00 | 1775.97 |
| Green, Wyatt, J,18606 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Huang, Jon,22508 | 799.48 | 0.00 | 0.00 | 0.00 | 799.48 |
| Raje, Nicolas,12827 | 4461.40 | 0.00 | 0.00 | 2071.42 | 2389.98 |
| Raje, Katrina,20911 | 611.96 | 0.00 | 0.00 | 0.00 | 611.96 |
| Ward, Grace, S,23356 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Huang, Franklin, M,22612 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Gomez, Albert, M,12383 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Rubio, Alfredo, D,17929 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Sharma, Shaun, L,14148 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Collins, Robert,11280 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Gonzales, Oscar, H,27481 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
| Cook, Zoe,24616 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Clark, Alexandra, R,23271 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Griffin, Adam,18669 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carter, Luke, M,14635 | 37.21 | 0.00 | 0.00 | 0.00 | 37.21 |
Generated 2025-12-23 12:07:02.095 UTC