[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 250 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Guo, Kristen, A,12033 | 5949.23 | 0.00 | 3578.27 | 0.00 | 2370.96 |
| Butler, Noah, E,12164 | 5908.26 | 0.00 | 3578.27 | 2329.99 | 0.00 |
| Xie, Yolanda,12841 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Torres, Kristi, M,14884 | 1883.56 | 0.00 | 699.10 | 0.00 | 1184.46 |
| Jenkins, Luke,26084 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Moreno, Jill, E,13537 | 5910.22 | 0.00 | 3578.27 | 0.00 | 2331.95 |
| Rogers, Mason, E,12779 | 5980.23 | 0.00 | 3578.27 | 0.00 | 2401.96 |
| Williams, Megan, A,12884 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Harrison, Thomas,12362 | 5904.23 | 0.00 | 3578.27 | 0.00 | 2325.96 |
| Adams, Robert, Q,12901 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Clark, Daniel, L,15016 | 1498.58 | 0.00 | 699.10 | 0.00 | 799.48 |
| Clark, Abigail,12772 | 5913.24 | 0.00 | 3578.27 | 0.00 | 2334.97 |
| Hall, Jasmine, M,12446 | 5944.73 | 0.00 | 3578.27 | 0.00 | 2366.46 |
| Rodriguez, Ian, W,12709 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Anderson, Jonathan, R,12885 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Alexander, Kaitlyn, T,12915 | 5896.19 | 0.00 | 3578.27 | 0.00 | 2317.92 |
| Henderson, Taylor, M,19051 | 3104.57 | 0.00 | 699.10 | 0.00 | 2405.47 |
| Butler, Antonio,12756 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Coleman, Sarah, S,26111 | 5794.05 | 0.00 | 3374.99 | 0.00 | 2419.06 |
| Campbell, Jonathan, D,12784 | 5985.22 | 0.00 | 3578.27 | 0.00 | 2406.95 |
| Thompson, Sarah,12423 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Zheng, Autumn, A,19041 | 3089.08 | 0.00 | 699.10 | 0.00 | 2389.98 |
| Gao, Kristen,12774 | 5943.23 | 0.00 | 3578.27 | 0.00 | 2364.96 |
| Bryant, Jordyn,12766 | 4417.73 | 0.00 | 3578.27 | 0.00 | 839.46 |
| Russell, Vanessa, M,12917 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Sanchez, Sean,12452 | 5935.55 | 0.00 | 3578.27 | 0.00 | 2357.28 |
| Gray, Arianna,14914 | 1592.57 | 0.00 | 699.10 | 0.00 | 893.47 |
| Smith, Jonathan, L,12762 | 5933.26 | 0.00 | 3578.27 | 0.00 | 2354.99 |
| Ortega, Jamie,14978 | 4209.21 | 0.00 | 3578.27 | 0.00 | 630.94 |
| Lewis, Ian,12707 | 5948.23 | 0.00 | 3578.27 | 0.00 | 2369.96 |
| Henderson, Benjamin, R,14445 | 100.46 | 0.00 | 0.00 | 0.00 | 100.46 |
| Winston, Gregory, R,14243 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Pal, Lindsay, E,14943 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Xu, Wayne, M,18014 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Anand, Shaun,25524 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Kelly, Mariah, L,19111 | 609.95 | 0.00 | 0.00 | 0.00 | 609.95 |
| Bell, Bailey, E,13203 | 4491.53 | 0.00 | 2181.56 | 0.00 | 2309.97 |
| Madan, Tina, M,24347 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Subram, Ruben,12187 | 5908.25 | 0.00 | 3578.27 | 2329.98 | 0.00 |
| Miller, Joshua,15050 | 4206.24 | 0.00 | 3578.27 | 0.00 | 627.97 |
| Rogers, Erin,12364 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Morris, Brianna, P,12912 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Parker, Sierra, J,12206 | 5908.25 | 0.00 | 3578.27 | 2329.98 | 0.00 |
| Lee, Daniel,26098 | 5793.05 | 0.00 | 3399.99 | 0.00 | 2393.06 |
| Cai, Leah,18125 | 5739.50 | 0.00 | 1000.44 | 0.00 | 4739.06 |
| Simmons, Ethan,13210 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Bennett, Kaitlyn, L,16942 | 2751.42 | 0.00 | 1000.44 | 1750.98 | 0.00 |
| Munoz, Erika,15114 | 6918.87 | 0.00 | 2181.56 | 2420.34 | 2316.97 |
| Ramirez, Mackenzie, M,15116 | 7212.86 | 0.00 | 2443.35 | 2428.05 | 2341.46 |
| Garcia, Manuel,13779 | 3063.00 | 0.00 | 2181.56 | 0.00 | 881.44 |
| Deng, Andres,13667 | 3001.04 | 0.00 | 2181.56 | 819.48 | 0.00 |
| Mitchell, Jenna,13226 | 4564.49 | 0.00 | 2181.56 | 0.00 | 2382.93 |
| Alonso, Joe, F,28766 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Chander, Terry, G,26127 | 2049.10 | 0.00 | 2049.10 | 0.00 | 0.00 |
| Anderson, Chloe, R,13986 | 1893.91 | 0.00 | 1000.44 | 893.47 | 0.00 |
| Ross, Thomas, B,26249 | 2071.42 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Rivera, Morgan, S,12949 | 4558.52 | 0.00 | 2181.56 | 0.00 | 2376.96 |
| Adams, Elijah, L,13214 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Kapoor, Kristi,19052 | 3140.27 | 0.00 | 782.99 | 0.00 | 2357.28 |
| Gill, Joe,13766 | 3001.04 | 0.00 | 2181.56 | 819.48 | 0.00 |
| Rubio, Orlando,19910 | 3188.46 | 0.00 | 782.99 | 0.00 | 2405.47 |
| Wright, Fernando, L,12923 | 4486.54 | 0.00 | 2181.56 | 0.00 | 2304.98 |
Generated 2025-11-03 15:28:35.068 UTC