[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 375 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 36.27 | 74.48 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Rogers, Brianna,22536 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Martin, Joy, L,13544 | 108.44 | 0.00 | 0.00 | 0.00 | 108.44 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Rivera, Bryan,18160 | 6914.59 | 0.00 | 0.00 | 2181.56 | 4733.03 |
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Shan, Jon,24151 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| He, Wesley, I,17849 | 3025.53 | 0.00 | 0.00 | 2181.56 | 843.97 |
| Ye, Kelli,19470 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Martin, Carolyn, M,12652 | 182.94 | 0.00 | 0.00 | 0.00 | 182.94 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Zhou, Alejandro, A,12304 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Li, Jeffery,17969 | 3040.31 | 0.00 | 0.00 | 2443.35 | 596.96 |
| Perez, Manuel, C,13777 | 7147.07 | 3578.27 | 0.00 | 0.00 | 3568.80 |
| Raman, Cynthia, P,27786 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Richardson, Ian,11414 | 7191.77 | 0.00 | 3399.99 | 2398.97 | 1392.81 |
| Mehta, Kristina, R,20165 | 3191.42 | 0.00 | 699.10 | 0.00 | 2492.32 |
| Carlson, Kendra,18044 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Anderson, Cameron, L,16595 | 6901.38 | 0.00 | 0.00 | 2181.56 | 4719.82 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 4490.48 | 2297.28 |
| Parker, Haley,14694 | 156.94 | 0.00 | 0.00 | 78.98 | 77.96 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 39.98 | 36.96 |
| Arun, Andre, E,12287 | 5720.37 | 0.00 | 0.00 | 3331.92 | 2388.45 |
| Sanz, Joanna, L,25732 | 638.95 | 0.00 | 0.00 | 638.95 | 0.00 |
| Carlson, Felicia,19502 | 3565.36 | 0.00 | 0.00 | 3565.36 | 0.00 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 123.47 | 0.00 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Beck, Cristina, J,12284 | 5625.25 | 0.00 | 0.00 | 3295.26 | 2329.99 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 118.47 | 33.98 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Xu, Gilbert,22554 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Wu, Heather, M,19261 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Ramos, Diana, J,28733 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Howard, Carlos,27891 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Wilson, Jacob, H,15078 | 6675.60 | 0.00 | 3578.27 | 0.00 | 3097.33 |
| Lopez, Janelle, G,25500 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sharma, Latoya,19260 | 1592.71 | 0.00 | 1000.44 | 0.00 | 592.27 |
| Sun, Alisha,18048 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Alvarez, Roberto,28387 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Mr., Sazanovich, Vadim,14847 | 6725.57 | 0.00 | 3578.27 | 0.00 | 3147.30 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Brooks, Haley, S,17193 | 134.96 | 0.00 | 0.00 | 74.98 | 59.98 |
| Zeng, Christy, L,15441 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Muñoz, Kari,19520 | 87.97 | 0.00 | 0.00 | 87.97 | 0.00 |
| Dominguez, Jessie, A,25628 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2791.45 | 2319.99 |
Generated 2025-11-03 15:33:16.344 UTC