[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 562 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Watson, Ian, G,26398 | 1758.95 | 0.00 | 0.00 | 0.00 | 1758.95 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Luo, Katrina, J,18147 | 6930.59 | 0.00 | 0.00 | 2181.56 | 4749.03 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Scott, Jason,22557 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Henderson, Marissa,13816 | 260.83 | 0.00 | 0.00 | 0.00 | 260.83 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Romero, Teresa, A,26834 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Shan, Jon,24151 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 0.00 | 137.94 |
| Yuan, Kristin, C,24114 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Goldberg, Nicolas,27789 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Arun, Emmanuel, R,28463 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Robinson, Matthew, D,29376 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, Jermaine,11488 | 8090.33 | 0.00 | 3374.99 | 2322.28 | 2393.06 |
| Barnes, Isabelle, C,15453 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Cook, Carlos, R,26955 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Tony,24212 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Randall, Kristi,13665 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Liu, Mandy,17888 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Rai, Sheena,29393 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Deng, Drew, E,17882 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Miller, Emily, R,11333 | 8163.31 | 3399.99 | 0.00 | 2344.26 | 2419.06 |
| Martin, Audrey,13791 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Gonzales, Emma, P,15681 | 105.56 | 0.00 | 0.00 | 33.98 | 71.58 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Sai, Marco,24840 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Rodriguez, Chelsea,12525 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Sanz, Randall, D,22539 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Goel, Latoya, C,11239 | 7511.55 | 3374.99 | 0.00 | 2353.95 | 1782.61 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Yuan, Gregory,21822 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Kumar, Dustin, R,26846 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Ramos, Cheryl, A,25682 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Suarez, Marie,29429 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Prasad, Frederick,17810 | 87.94 | 0.00 | 0.00 | 73.96 | 13.98 |
| Navarro, Armando,19942 | 3034.07 | 699.10 | 0.00 | 0.00 | 2334.97 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Perez, Levi,26830 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Martin, Mallory, J,13794 | 7212.06 | 0.00 | 3578.27 | 0.00 | 3633.79 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Chande, Christy,26214 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Shan, Casey, C,17782 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Ramos, Jamie, L,27852 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Andersen, Kathryn,21865 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Moreno, Derrick, C,18625 | 2753.82 | 0.00 | 0.00 | 2181.56 | 572.26 |
| Zhu, Autumn,14840 | 157.96 | 0.00 | 0.00 | 33.98 | 123.98 |
| Richardson, Julia, N,27331 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Watson, Jan, K,13680 | 5948.24 | 3578.27 | 0.00 | 0.00 | 2369.97 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 2398.47 | 1249.84 |
Generated 2025-11-04 04:41:49.026 UTC