[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 3033.33 | 0.00 |
| Lin, Marshall,16822 | 7176.38 | 0.00 | 0.00 | 2443.35 | 4733.03 |
| Hu, Lisa, L,21118 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Yuan, Kelvin, L,25692 | 66.97 | 0.00 | 0.00 | 66.97 | 0.00 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Brown, Nicole,11334 | 8154.02 | 3399.99 | 0.00 | 2334.97 | 2419.06 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rai, Maurice, S,16328 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Zhang, Brent, L,18173 | 7189.35 | 0.00 | 0.00 | 2443.35 | 4746.00 |
| Rogers, Christina, F,21668 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Garcia, Carla,14172 | 75.74 | 0.00 | 0.00 | 0.00 | 75.74 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Ruiz, Theodore,20052 | 3214.03 | 699.10 | 0.00 | 2514.93 | 0.00 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Rana, Martin,24213 | 1214.46 | 0.00 | 0.00 | 0.00 | 1214.46 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Perez, Michele, K,13772 | 5928.25 | 3578.27 | 0.00 | 0.00 | 2349.98 |
| Tang, Kurt, G,13847 | 5888.24 | 3578.27 | 0.00 | 0.00 | 2309.97 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Madan, Joel, C,17887 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Perez, Manuel, C,13777 | 7147.07 | 3578.27 | 0.00 | 0.00 | 3568.80 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Nara, Casey, E,17812 | 2983.33 | 0.00 | 0.00 | 2181.56 | 801.77 |
| McDonald, Jenny,16543 | 53.96 | 0.00 | 0.00 | 0.00 | 53.96 |
| Sanchez, Morgan, J,12262 | 119.45 | 0.00 | 0.00 | 60.47 | 58.98 |
| Raje, Kate,17974 | 2791.46 | 0.00 | 0.00 | 2181.56 | 609.90 |
| Madan, Edgar, M,27131 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ross, Gabriel, K,16314 | 111.95 | 0.00 | 0.00 | 39.98 | 71.97 |
| Gomez, Melody,25805 | 2501.31 | 0.00 | 0.00 | 0.00 | 2501.31 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Diaz, Jaime, A,17795 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Xie, Tara,19912 | 3427.39 | 0.00 | 0.00 | 1000.44 | 2426.95 |
| Munoz, Billy, J,14150 | 6705.59 | 0.00 | 3578.27 | 777.34 | 2349.98 |
| Andersen, Jerry,20975 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Lu, Mandy,14988 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 8.99 | 36.27 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 782.99 | 0.00 | 2638.94 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Phillips, Gabriel, R,29443 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Gray, Natalie, L,14165 | 5910.55 | 0.00 | 3578.27 | 0.00 | 2332.28 |
| Malhotra, Evelyn,12853 | 4354.08 | 0.00 | 0.00 | 2049.10 | 2304.98 |
| Hernandez, Larry,17840 | 228.96 | 0.00 | 0.00 | 0.00 | 228.96 |
| Blanco, Clinton, J,14195 | 8316.29 | 0.00 | 3578.27 | 0.00 | 4738.02 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Ms., Shock, Misty,24869 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harrison, Reginald, M,23774 | 1234.45 | 0.00 | 0.00 | 0.00 | 1234.45 |
| Richardson, Megan, M,15662 | 5253.07 | 0.00 | 3578.27 | 0.00 | 1674.80 |
| Nara, Shawn, C,13845 | 5917.24 | 3578.27 | 0.00 | 0.00 | 2338.97 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 777.34 | 2373.96 |
| Liu, Shannon, D,11250 | 7116.25 | 3399.99 | 0.00 | 2339.97 | 1376.29 |
| Perez, Bruce, R,16935 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Wu, Jaclyn,24035 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Jackson, Kayla, R,20060 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
Generated 2025-11-03 01:30:42.362 UTC