[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1156 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rai, Arturo, T,22504 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Smith, Terrance, I,19424 | 3511.76 | 0.00 | 0.00 | 3511.76 | 0.00 |
| Moore, Anna, A,12744 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Suri, Andre, D,24189 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Price, Brittany,12492 | 5166.41 | 0.00 | 0.00 | 2049.10 | 3117.31 |
| Reed, Jesse, E,22429 | 1777.95 | 0.00 | 0.00 | 0.00 | 1777.95 |
| Carlson, Jamie,23770 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Gomez, Kristi,26911 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Prasad, Jillian,12860 | 4464.09 | 0.00 | 0.00 | 2049.10 | 2414.99 |
| Martin, Sabrina, D,25578 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rai, Jon,25642 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Xie, Alejandro,25781 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Torres, Audrey,16571 | 52.92 | 0.00 | 0.00 | 0.00 | 52.92 |
| Cai, Jamie, S,13505 | 127.93 | 0.00 | 0.00 | 0.00 | 127.93 |
| Diaz, Larry, T,13664 | 210.25 | 0.00 | 0.00 | 0.00 | 210.25 |
| Garcia, Arthur, T,29413 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Zhou, Martha, M,14804 | 138.96 | 0.00 | 0.00 | 0.00 | 138.96 |
| Kim, Carmen,25502 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Ye, Sandra,24689 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Lopez, Raymond, G,27317 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Xie, Franklin, A,17747 | 2743.53 | 0.00 | 0.00 | 2181.56 | 561.97 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Gao, Margaret,16401 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Goel, Terrence, M,19389 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Shen, Bethany, C,17903 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Harris, Jonathan,26220 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Andersen, Bethany,25324 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Cox, Taylor,11436 | 81.76 | 0.00 | 0.00 | 0.00 | 81.76 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ye, Darryl,17790 | 3039.31 | 0.00 | 0.00 | 2443.35 | 595.96 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Vazquez, Pedro, A,15686 | 72.58 | 0.00 | 0.00 | 0.00 | 72.58 |
| Carlson, Melinda,20921 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Sharma, Dawn,23987 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Carlson, Kristine, C,28753 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Luo, Chad, R,21040 | 2566.95 | 0.00 | 0.00 | 2566.95 | 0.00 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Kapoor, Heidi, D,17937 | 3068.82 | 0.00 | 0.00 | 2443.35 | 625.47 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raman, Ebony,19348 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Reed, Rachel, E,12644 | 6838.12 | 0.00 | 0.00 | 2049.10 | 4789.02 |
| She, Kurt,26206 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Deng, Tonya, O,17936 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
Generated 2025-12-22 02:41:31.726 UTC