[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 91 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Kathleen, C,28375 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| _SUM | 3388349.72 | 33221.07 | 554871.66 | 778572.36 | 2021684.63 |
| Gutierrez, Kellie, K,17966 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Hernandez, Jonathon, F,15699 | 6969.57 | 0.00 | 2181.56 | 0.00 | 4788.01 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Shan, Christine, R,26895 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Kumar, Maurice, L,22600 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Serrano, Jimmy, L,17632 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rivera, Garrett,22642 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hu, Candice,27818 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| She, Donna, D,19346 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Smith, Terrance, I,19424 | 3511.76 | 0.00 | 0.00 | 3511.76 | 0.00 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Munoz, Rodney,12836 | 68.46 | 0.00 | 0.00 | 0.00 | 68.46 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Gutierrez, Marie, F,29431 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Turner, Charles,24188 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 0.00 | 2533.93 |
| Prasad, Cindy, C,26914 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| Kovár, Abby, K,25605 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Sai, Phillip, M,13563 | 5948.23 | 3578.27 | 0.00 | 0.00 | 2369.96 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Zhang, Randy,12601 | 55.91 | 0.00 | 0.00 | 0.00 | 55.91 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Ortega, Hector, E,16054 | 3759.36 | 0.00 | 2181.56 | 0.00 | 1577.80 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Holt, Katie,27946 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Navarro, Gary, E,13561 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Zhang, Jake,22616 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Wu, Rafael,12745 | 5199.72 | 0.00 | 0.00 | 2071.42 | 3128.30 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| He, Claudia, F,24093 | 2466.32 | 0.00 | 0.00 | 0.00 | 2466.32 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Sanchez, Pamela,20879 | 3284.30 | 0.00 | 0.00 | 782.99 | 2501.31 |
| Xie, Calvin, A,24858 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Neil, C,18181 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2049.10 | 3120.26 |
| Romero, Mathew, L,16043 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Alonso, Micheal, W,19307 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Sandoval, Giraldo, Hierro,22634 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
Generated 2026-01-04 05:01:39.655 UTC