[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 124 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Smith, Ethan,14530 | 72.86 | 0.00 | 0.00 | 36.59 | 36.27 |
| Fernandez, Jillian, K,12599 | 5649.21 | 0.00 | 0.00 | 2071.42 | 3577.79 |
| Rubio, Micheal, K,12622 | 5135.41 | 0.00 | 0.00 | 2049.10 | 3086.31 |
| Nicholls, Jay, K,17813 | 3020.30 | 0.00 | 0.00 | 2443.35 | 576.95 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Patterson, Emma, J,14941 | 6865.57 | 0.00 | 3578.27 | 0.00 | 3287.30 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Kelly, Marcus, A,25699 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
| Sanchez, Brian, F,20931 | 3273.17 | 0.00 | 0.00 | 782.99 | 2490.18 |
| Romero, Gerald, K,19322 | 1565.43 | 0.00 | 0.00 | 1000.44 | 564.99 |
| Zhao, Rafael,13412 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Diaz, Austin, M,12550 | 86.75 | 0.00 | 0.00 | 0.00 | 86.75 |
| Gao, Lacey, C,16531 | 3291.80 | 0.00 | 0.00 | 2443.35 | 848.45 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Suri, Clifford,19369 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ramos, Orlando,24154 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Suri, Tabitha,27957 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 60.47 | 58.98 |
| Anand, Colleen, N,12647 | 6886.60 | 0.00 | 0.00 | 2049.10 | 4837.50 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Bradley, Isabel,27783 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gill, Clinton,26210 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 2071.42 | 4776.34 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Zhou, Glenn, A,12326 | 63.98 | 0.00 | 0.00 | 0.00 | 63.98 |
| Jimenez, Nelson,14697 | 6684.58 | 0.00 | 3578.27 | 776.33 | 2329.98 |
| Gutierrez, Jimmy, M,11494 | 6973.81 | 0.00 | 3399.99 | 2329.98 | 1243.84 |
| Hayes, Seth, C,17757 | 79.97 | 0.00 | 0.00 | 0.00 | 79.97 |
| Sharma, Dylan,19066 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Alvarez, Robin, V,11243 | 7164.25 | 3399.99 | 0.00 | 3175.30 | 588.96 |
| Blanco, Albert, W,13581 | 8374.79 | 3578.27 | 0.00 | 0.00 | 4796.52 |
| Alonso, Briana,21830 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Munoz, Rodney,12836 | 68.46 | 0.00 | 0.00 | 0.00 | 68.46 |
| Serrano, Jill,24026 | 1212.97 | 0.00 | 0.00 | 0.00 | 1212.97 |
| Chen, Marshall, E,19037 | 4858.34 | 0.00 | 0.00 | 2443.35 | 2414.99 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Malhotra, Johnathan,17723 | 83.94 | 0.00 | 0.00 | 64.97 | 18.97 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Liang, Crystal, J,11549 | 7023.77 | 0.00 | 3399.99 | 2309.97 | 1313.81 |
| Schmidt, Derrick, R,22605 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Sara, Henry, L,20892 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Carlson, Gary, R,24115 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arun, Meagan, W,23930 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Nara, Drew, A,26944 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
Generated 2025-11-03 08:34:18.393 UTC