[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 500 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Garcia, Bruce, B,18037 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gao, Claudia,13690 | 7162.08 | 3578.27 | 0.00 | 0.00 | 3583.81 |
| Rana, Kristopher, W,22550 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Gutierrez, Robin,21104 | 2566.95 | 0.00 | 0.00 | 782.99 | 1783.96 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sun, Heather,28729 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Ortega, Robin,17798 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Luo, Terry, H,26850 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 2443.35 | 0.00 | 799.48 |
| Carlson, Linda, J,12609 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Perez, Bruce, R,16935 | 94.96 | 0.00 | 0.00 | 0.00 | 94.96 |
| Jenkins, Caleb,14184 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 2294.99 | 2419.06 |
| Ramos, Felicia,11557 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Diaz, Jimmy, D,25474 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Romero, Armando, A,12596 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Mehta, Ivan, S,26390 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Madan, Ross, C,27929 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Travers, Jill, A,16602 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Liu, Shannon, D,11250 | 7116.25 | 3399.99 | 0.00 | 2339.97 | 1376.29 |
| Navarro, Lawrence,27939 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Dominguez, Naomi, B,14720 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Jenkins, Adam, M,18633 | 2793.50 | 0.00 | 0.00 | 2181.56 | 611.94 |
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Coleman, Austin, V,14865 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Alexander, Ana, R,22637 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Lal, Lindsay, H,20557 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Lopez, Holly,26876 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Andersen, Katrina,19032 | 6938.58 | 0.00 | 0.00 | 2181.56 | 4757.02 |
| Dominguez, Felicia, R,14196 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| King, Adam, M,16932 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 782.99 | 0.00 | 2478.34 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 2506.95 | 0.00 |
| Chapman, Pedro,17785 | 67.26 | 0.00 | 0.00 | 67.26 | 0.00 |
| Malhotra, Roy, P,23220 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Sanz, Kendra,17753 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Howard, Carlos,27891 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Shen, Derek, T,22586 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
Generated 2025-11-04 04:44:03.411 UTC