[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Phillips, Jada, S,23143 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Jimenez, Kristy, E,23299 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Cox, Bryce,20205 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Price, Mya, L,17569 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Sanchez, Carlos, W,17570 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Gutierrez, Kristi,22638 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Kumar, Alisha, I,16466 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Madan, Chelsea, O,24198 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Jones, Jasmine, J,13320 | 21.98 | 0.00 | 0.00 | 21.98 | 0.00 |
| Moyer, Jay,13822 | 2944.94 | 0.00 | 0.00 | 0.00 | 2944.94 |
| Parker, Gabrielle,22223 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ward, Lauren,28642 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Gonzalez, Brett, J,24618 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Hernandez, Meredith, B,13950 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Patterson, Victoria,16279 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Sai, Heidi, S,22737 | 165.22 | 0.00 | 0.00 | 0.00 | 165.22 |
| Gonzalez, Erick, E,26399 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| Rodriguez, Samuel, P,22751 | 133.47 | 0.00 | 0.00 | 0.00 | 133.47 |
| Perry, David, W,18992 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Wood, Miranda,15854 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Watson, Chase,27096 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Wood, Morgan, M,18760 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| James, Makayla, E,29258 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Vazquez, Gina,14829 | 90.47 | 0.00 | 0.00 | 0.00 | 90.47 |
| Kelly, Melissa,16037 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Victor,18022 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Ma, Alvin,15099 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Perez, Tina, J,25322 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Pal, Kenneth, G,24384 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Zhang, Justin,26322 | 2912.26 | 0.00 | 2071.42 | 840.84 | 0.00 |
| Ortega, Jonathon, L,11694 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Diaz, Logan, A,12025 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Prasad, Tammy,19396 | 1169.46 | 0.00 | 0.00 | 1169.46 | 0.00 |
| Hughes, Marcus, A,17438 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| James, Bryan, E,13431 | 4592.50 | 0.00 | 2181.56 | 0.00 | 2410.94 |
| Brown, Olivia,11218 | 39.58 | 0.00 | 0.00 | 2.29 | 37.29 |
| Ramirez, Nicole,11141 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Sanchez, Emma,11774 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Wood, Aidan,14747 | 1503.58 | 0.00 | 699.10 | 0.00 | 804.48 |
| Evans, Madeline,21445 | 113.47 | 0.00 | 0.00 | 113.47 | 0.00 |
| Coleman, Thomas,17672 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Javier Castrejón, Francisco,20497 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Brown, Christopher, C,20295 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Prasad, Raymond,17384 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Davis, Kayla,16381 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Mr., Robinett, David, R.,11377 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Lopez, Troy, M,19427 | 1967.45 | 0.00 | 0.00 | 782.99 | 1184.46 |
| Allen, Sydney, K,13363 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Li, Omar,21141 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lal, Michele, A,14171 | 6615.70 | 0.00 | 3578.27 | 0.00 | 3037.43 |
| Campbell, Allison,21143 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Simmons, Ryan,25148 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Morris, Bryce,19724 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Reed, Alex, I,28865 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Anderson, Alexander, G,22723 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Perry, Emma,21744 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Perry, Alexandra, L,18750 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Brown, Hunter,27036 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Goel, Omar, M,12649 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Nath, Karla,22317 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Alvarez, Shannon,11551 | 53.99 | 0.00 | 0.00 | 53.99 | 0.00 |
| Natsuhara, Dave, E,23611 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Patel, Michele,15611 | 54.25 | 0.00 | 0.00 | 0.00 | 54.25 |
| Nelson, Blake, I,13086 | 4805.62 | 0.00 | 2443.35 | 0.00 | 2362.27 |
| Diaz, Kristy, A,16105 | 2361.95 | 0.00 | 0.00 | 0.00 | 2361.95 |
| Yuan, Johnny,28915 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Adams, Wyatt,14890 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Thompson, Alexander,27114 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Barnes, Marissa,23701 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rodriguez, Sarah, K,21369 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Cai, Colin,17739 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| King, Stephanie, W,17754 | 2755.42 | 0.00 | 0.00 | 1000.44 | 1754.98 |
| Ortega, Wendy, B,15094 | 7108.87 | 0.00 | 0.00 | 2181.56 | 4927.31 |
| Morgan, Shelby,28343 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Stewart, Carlos, E,27995 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Campbell, Morgan, W,26010 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Moreno, Gina, J,23049 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| She, Jake,17781 | 7187.37 | 0.00 | 0.00 | 2443.35 | 4744.02 |
| Gray, Lauren,20018 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gray, Destiny, B,19633 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Garcia, Devin, A,14246 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Perry, Eduardo, R,16774 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Black, Mitchell, F,25691 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Chen, Damien, A,23979 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Flores, Ethan, B,13437 | 80.96 | 0.00 | 0.00 | 80.96 | 0.00 |
| Subram, Manuel,25680 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Wright, Edward,22744 | 54.21 | 0.00 | 0.00 | 0.00 | 54.21 |
| Davis, Joshua, M,18410 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Shan, Ethan,12178 | 5933.25 | 0.00 | 3578.27 | 2354.98 | 0.00 |
| Srini, Sergio,26225 | 742.35 | 0.00 | 0.00 | 742.35 | 0.00 |
| Deng, Shawna, C,27791 | 777.34 | 0.00 | 0.00 | 777.34 | 0.00 |
| Garcia, Cory, B,21546 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raje, Carl, J,13795 | 779.48 | 0.00 | 0.00 | 779.48 | 0.00 |
| Cook, Amanda, S,11279 | 44.57 | 0.00 | 0.00 | 2.29 | 42.28 |
| Bradley, Paige,20506 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Campbell, Sean, L,20071 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Jones, Megan,20115 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Hughes, Emily,18123 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Lal, Noah, L,15069 | 71.95 | 0.00 | 0.00 | 71.95 | 0.00 |
| Gill, Casey,16040 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Diaz, Spencer, J,13892 | 3021.04 | 0.00 | 0.00 | 3021.04 | 0.00 |
| Lopez, Devin,24492 | 791.32 | 0.00 | 0.00 | 791.32 | 0.00 |
| Blue, Maria, M,16226 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Sara, Francisco, A,12296 | 9586.37 | 0.00 | 0.00 | 4884.34 | 4702.03 |
| Watson, Gabriella, D,22333 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Patterson, Trevor, J,21158 | 49.97 | 0.00 | 0.00 | 49.97 | 0.00 |
| Chandra, Ruth,16208 | 119.96 | 0.00 | 0.00 | 119.96 | 0.00 |
| Raji, Bonnie,12156 | 5920.24 | 0.00 | 3578.27 | 2341.97 | 0.00 |
| Parker, Dalton,13064 | 4579.47 | 0.00 | 2181.56 | 0.00 | 2397.91 |
| Wood, Sarah, L,26621 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Ward, Riley,25552 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Chander, Jon, L,13257 | 5363.01 | 0.00 | 0.00 | 539.99 | 4823.02 |
| Luo, Jenny, L,19474 | 1589.75 | 0.00 | 0.00 | 782.99 | 806.76 |
| Scott, Xavier,14764 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lu, Eugene, N,14187 | 36.59 | 0.00 | 0.00 | 0.00 | 36.59 |
| Hill, Mary, M,25622 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Anand, Kate, K,13263 | 10872.06 | 0.00 | 3578.27 | 0.00 | 7293.79 |
| Richardson, Christina,12199 | 194.98 | 0.00 | 0.00 | 0.00 | 194.98 |
| Srini, Mayra,22666 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ferrier, Gilbert, I,19825 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Johnson, Grace, M,18093 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lal, Dylan, D,11958 | 159.96 | 0.00 | 0.00 | 0.00 | 159.96 |
| Gonzalez, Henry, W,26224 | 777.34 | 0.00 | 0.00 | 777.34 | 0.00 |
| Nelson, Jackson,24675 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Harris, Wyatt,21748 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
Generated 2025-11-04 05:53:00.548 UTC