[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 62 < SKIP 187 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| James, Charles,28523 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Suri, Ebony, A,22808 | 2478.34 | 0.00 | 0.00 | 2478.34 | 0.00 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2049.10 | 3120.26 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gutierrez, Craig,19049 | 4838.30 | 0.00 | 0.00 | 2443.35 | 2394.95 |
| Zhu, Arturo, M,24575 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zheng, Trisha,22437 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Wu, Cedric, E,21025 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Suri, Cynthia,22589 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Gill, Paula, W,28524 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Lopez, Jonathan, D,15103 | 107.85 | 0.00 | 0.00 | 0.00 | 107.85 |
| Washington, Cassidy,17701 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 0.00 | 4719.82 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jimenez, Roy,12334 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Ortega, Kendra,25592 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Rai, Barbara, J,22451 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rana, Roy, M,22667 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Vance, Heidi,14771 | 6689.58 | 0.00 | 3578.27 | 0.00 | 3111.31 |
| Black, Nina, L,17968 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Dennis,18187 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Subram, Dominique, S,15620 | 5959.72 | 0.00 | 3578.27 | 0.00 | 2381.45 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Rai, Cassie, R,14194 | 168.93 | 0.00 | 0.00 | 0.00 | 168.93 |
| Moreno, Briana, L,28734 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Suri, Brenda, D,22643 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Hu, Candice,27818 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Goel, Louis,24055 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Rana, Allen, D,19036 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martinez, David, R,20869 | 2542.96 | 0.00 | 0.00 | 782.99 | 1759.97 |
| Scott, Mackenzie, L,25676 | 66.97 | 0.00 | 0.00 | 0.00 | 66.97 |
| Moreno, Francis, A,26962 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Mehta, Ruth,15702 | 6917.54 | 0.00 | 2181.56 | 0.00 | 4735.98 |
| Xie, Colleen, C,12133 | 5830.68 | 0.00 | 0.00 | 2071.42 | 3759.26 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Hall, Sydney, T,17880 | 39.55 | 0.00 | 0.00 | 0.00 | 39.55 |
| Liu, Jorge, J,20592 | 3113.22 | 0.00 | 782.99 | 0.00 | 2330.23 |
| Prasad, Veronica, J,24199 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Fernandez, Bruce, E,26888 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Alexander, Natalie, A,25760 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| Rana, Geoffrey,28745 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| Nicholls, Jay, K,17813 | 3020.30 | 0.00 | 0.00 | 2443.35 | 576.95 |
| Russell, Natalie, M,20900 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Munoz, Kristine,16446 | 3093.03 | 0.00 | 0.00 | 2181.56 | 911.47 |
| Alvarez, Deanna, K,24720 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gomez, Kristi,26911 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Andersen, Keith,11612 | 6795.12 | 0.00 | 0.00 | 2049.10 | 4746.02 |
| Martin, Darren,22695 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Rodriguez, Gerald,12216 | 6955.41 | 0.00 | 0.00 | 2071.42 | 4883.99 |
| Barnes, Vanessa,13810 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Rana, Summer, M,25703 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Powell, Christian,19522 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rodriguez, Jay, M,28411 | 134.95 | 0.00 | 0.00 | 0.00 | 134.95 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 0.00 | 4752.52 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 0.00 | 78.86 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Sanchez, Ruben, S,13688 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Vance, Meagan, F,29405 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Kelly, Richard,17991 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Navarro, Dwayne, H,11615 | 5205.71 | 0.00 | 0.00 | 2848.76 | 2356.95 |
| Madan, Harold, A,23938 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Alvarez, Julio,26205 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Navarro, Wendy, C,20881 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Xie, Gilbert,14831 | 5912.73 | 0.00 | 3578.27 | 0.00 | 2334.46 |
| Prasad, Rachael, M,22535 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Holt, Roger,27140 | 575.71 | 0.00 | 0.00 | 0.00 | 575.71 |
| Munoz, Lori, M,22639 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Madan, Cindy, R,12259 | 86.75 | 0.00 | 0.00 | 0.00 | 86.75 |
| Gill, Kathleen,20713 | 3421.93 | 0.00 | 0.00 | 782.99 | 2638.94 |
| Sanz, Krista,27806 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Ortega, Hector, E,16054 | 3759.36 | 0.00 | 2181.56 | 0.00 | 1577.80 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Nara, Clarence, G,20054 | 3338.04 | 0.00 | 699.10 | 0.00 | 2638.94 |
| Raman, Lydia,26868 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Luo, Katrina, J,18147 | 6930.59 | 0.00 | 0.00 | 2181.56 | 4749.03 |
| Rana, Carolyn,21829 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Henderson, Dakota, M,16406 | 3110.05 | 0.00 | 0.00 | 2181.56 | 928.49 |
| Tang, Russell,18632 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Tang, Colleen, A,25731 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Suarez, Marie,29429 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| She, Clayton,13785 | 121.83 | 0.00 | 0.00 | 0.00 | 121.83 |
| Ye, Sandra,24689 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 0.00 | 123.47 |
| Coleman, Alexis, M,11244 | 7175.75 | 0.00 | 3399.99 | 2354.99 | 1420.77 |
Generated 2026-01-04 05:48:40.918 UTC