[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
| Davis, Zachary, L,16579 | 97.95 | 0.00 | 0.00 | 0.00 | 97.95 |
| Andersen, Christine, A,27945 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Coleman, Alexis, M,11244 | 7175.75 | 3399.99 | 0.00 | 3166.31 | 609.45 |
| Hu, Jake, L,24576 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Goel, Warren, A,13678 | 5933.25 | 3578.27 | 0.00 | 0.00 | 2354.98 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Ruiz, Theodore,20052 | 3214.03 | 699.10 | 0.00 | 2514.93 | 0.00 |
| Navarro, Erika, K,11476 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Suri, Brenda, D,22643 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Nara, Clarence, G,20054 | 3338.04 | 699.10 | 0.00 | 0.00 | 2638.94 |
| Rodriguez, Bryant, R,29360 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 2510.94 | 0.00 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Jackson, Kayla, R,20060 | 3142.45 | 699.10 | 0.00 | 0.00 | 2443.35 |
| Ramos, Kari, D,24702 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Pal, Michele,17814 | 133.93 | 0.00 | 0.00 | 29.98 | 103.95 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 2379.97 | 2442.03 |
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 36.27 | 49.97 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 777.34 | 2309.97 |
| Sun, Willie,19278 | 1575.42 | 0.00 | 1000.44 | 0.00 | 574.98 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Suri, Martin,16589 | 7343.69 | 0.00 | 0.00 | 2443.35 | 4900.34 |
| Xu, Willie, J,14157 | 6650.60 | 0.00 | 3578.27 | 777.34 | 2294.99 |
| Diaz, Kathleen, C,28375 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Madan, Cindy, R,12259 | 86.75 | 0.00 | 0.00 | 27.77 | 58.98 |
| Vazquez, Cheryl, A,17948 | 3045.30 | 0.00 | 0.00 | 2443.35 | 601.95 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Raman, Meredith,11381 | 8161.02 | 0.00 | 3399.99 | 2341.97 | 2419.06 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Gomez, Joe, E,16574 | 44.97 | 0.00 | 0.00 | 4.99 | 39.98 |
| Raman, Tammy,12126 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Ortega, Carrie, L,11353 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Ortega, Hector, E,16054 | 3759.36 | 0.00 | 2181.56 | 0.00 | 1577.80 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 663.44 | 0.00 |
| He, Lacey,14429 | 8394.29 | 0.00 | 3578.27 | 0.00 | 4816.02 |
| Jimenez, Renee,14778 | 6673.53 | 0.00 | 3578.27 | 0.00 | 3095.26 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Moreno, Reginald, H,16050 | 76.94 | 0.00 | 0.00 | 39.98 | 36.96 |
| Vazquez, Theodore, T,16831 | 7206.37 | 0.00 | 0.00 | 2443.35 | 4763.02 |
| Vazquez, Lee,14843 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Blanco, Meghan,17961 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Yang, Marshall, E,12564 | 110.75 | 0.00 | 0.00 | 36.27 | 74.48 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Zhao, Dennis,20173 | 3181.33 | 0.00 | 699.10 | 0.00 | 2482.23 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 78.98 | 28.99 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Ye, Dawn,25488 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Butler, Blake,13583 | 8375.29 | 3578.27 | 0.00 | 0.00 | 4797.02 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Malhotra, Meagan, L,27827 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Serrano, Sheila, C,21018 | 2515.25 | 0.00 | 0.00 | 782.99 | 1732.26 |
| Scott, Dalton,14975 | 5957.22 | 0.00 | 3578.27 | 0.00 | 2378.95 |
| Kumar, Nicolas, R,12292 | 5027.86 | 0.00 | 0.00 | 4464.09 | 563.77 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Andersen, Kathryn,21865 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Deng, Misty,14861 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Hayes, Riley,14833 | 6679.60 | 0.00 | 3578.27 | 0.00 | 3101.33 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Cheryl, A,12320 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Patel, Roy, A,14928 | 6706.57 | 0.00 | 3578.27 | 0.00 | 3128.30 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sara, Levi, S,12540 | 75.47 | 0.00 | 0.00 | 25.48 | 49.99 |
| Yuan, Bonnie, H,15048 | 6690.58 | 0.00 | 3578.27 | 0.00 | 3112.31 |
| Sanders, Jessica,17650 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Suarez, Julio, J,15058 | 6639.58 | 0.00 | 3578.27 | 0.00 | 3061.31 |
| Serrano, Walter, G,12299 | 4977.36 | 0.00 | 0.00 | 4428.38 | 548.98 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Rai, Kara, D,26970 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Townsend, Trinity, L,12367 | 160.45 | 0.00 | 0.00 | 49.99 | 110.46 |
| Anand, Wayne, H,22686 | 1243.44 | 0.00 | 0.00 | 1243.44 | 0.00 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kapoor, Carolyn, M,16459 | 47.26 | 0.00 | 0.00 | 7.28 | 39.98 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Ortega, Nelson,15118 | 8301.31 | 0.00 | 3578.27 | 0.00 | 4723.04 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 2429.46 | 1263.82 |
| Andersen, Jaclyn,11468 | 6959.82 | 0.00 | 3374.99 | 2319.99 | 1264.84 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| She, Deborah,25576 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Becker, Karla, M,12730 | 64.90 | 0.00 | 0.00 | 0.00 | 64.90 |
| Fernandez, Harold, C,29359 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Rubio, Jamie, W,27179 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gonzales, Isabella, R,14815 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Moreno, Paula, W,13554 | 5641.25 | 0.00 | 0.00 | 2071.42 | 3569.83 |
| Rivera, Katelyn,23948 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Xu, Erica, M,20863 | 3261.33 | 0.00 | 0.00 | 782.99 | 2478.34 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 32.60 | 39.98 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Henderson, Tristan,12224 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Chavez, Colleen, H,20049 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Diaz, Mariah,25465 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Xie, Mario,13687 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Prasad, Rachael, M,22535 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Alvarez, Robin, V,11243 | 7164.25 | 3399.99 | 0.00 | 3175.30 | 588.96 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Perez, Michele, K,13772 | 5928.25 | 3578.27 | 0.00 | 0.00 | 2349.98 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Griffin, Spencer,13784 | 7138.10 | 3578.27 | 0.00 | 0.00 | 3559.83 |
| Lu, Dawn, G,27833 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Wright, Logan, M,13783 | 5955.23 | 3578.27 | 0.00 | 0.00 | 2376.96 |
Generated 2025-11-01 20:24:47.170 UTC