[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 82 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chen, Alejandro,14947 | 6658.58 | 0.00 | 3578.27 | 0.00 | 3080.31 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Liang, Heather, E,20552 | 3034.07 | 0.00 | 699.10 | 0.00 | 2334.97 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Alonso, Eddie, L,16420 | 2959.00 | 0.00 | 0.00 | 2181.56 | 777.44 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Xie, Sheena,18041 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Alexander, Justin, M,12272 | 5139.73 | 0.00 | 0.00 | 2822.76 | 2316.97 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| She, Karla, T,12215 | 6890.73 | 0.00 | 0.00 | 2071.42 | 4819.31 |
| Xie, Carl, R,18136 | 6904.60 | 0.00 | 0.00 | 2181.56 | 4723.04 |
| Scott, Jonathan,23224 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Nara, Clarence, G,20054 | 3338.04 | 0.00 | 699.10 | 0.00 | 2638.94 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Raji, April, L,14981 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lal, Nichole, P,25753 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Nath, Tonya,24847 | 2552.82 | 0.00 | 0.00 | 0.00 | 2552.82 |
| Ramos, Felicia,11557 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Liang, Cedric, R,19941 | 3078.06 | 699.10 | 0.00 | 0.00 | 2378.96 |
| Chen, Krystal, D,13530 | 186.28 | 0.00 | 0.00 | 0.00 | 186.28 |
| Alvarez, Kathleen, R,17793 | 3250.11 | 0.00 | 0.00 | 2443.35 | 806.76 |
| Thompson, Benjamin,19435 | 3457.77 | 0.00 | 0.00 | 3457.77 | 0.00 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Lewis, Katherine,14816 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Shan, Russell,19500 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Sai, Jermaine, G,14934 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Sun, Claudia, J,14525 | 6665.58 | 0.00 | 3578.27 | 0.00 | 3087.31 |
| Raman, George, M,26359 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Russell, Carson,21116 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Jenkins, Caleb,14184 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Xu, Derek, M,20824 | 2512.96 | 0.00 | 0.00 | 2512.96 | 0.00 |
| Jones, Brianna,25546 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Chen, Dennis, M,17627 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Bailey, Ariana, J,13691 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Tang, Tonya,20917 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Kumar, Roger, C,15922 | 148.20 | 0.00 | 0.00 | 0.00 | 148.20 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ramos, Erik, M,25312 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Coleman, Alexis, M,11244 | 7175.75 | 0.00 | 3399.99 | 2354.99 | 1420.77 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Tang, Nichole, C,15630 | 5136.37 | 0.00 | 3578.27 | 806.76 | 751.34 |
| Lopez, Cassandra,22308 | 1768.96 | 0.00 | 0.00 | 0.00 | 1768.96 |
| Parker, Eric, H,27130 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Carlson, Dana, H,14863 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Xu, Shaun, N,27804 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Becker, Gilbert,14794 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Patel, Chelsea, P,19938 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Rana, Barry,14832 | 5938.24 | 0.00 | 3578.27 | 0.00 | 2359.97 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| She, Ramon,18000 | 3080.29 | 0.00 | 0.00 | 2443.35 | 636.94 |
| Ross, Gabriel, K,16314 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Raman, Douglas,24545 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Deng, Misty,14861 | 5976.74 | 0.00 | 3578.27 | 0.00 | 2398.47 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Martinez, Molly, S,13603 | 133.94 | 0.00 | 0.00 | 0.00 | 133.94 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Jiménez, Arthur, K,20982 | 2546.96 | 0.00 | 0.00 | 2546.96 | 0.00 |
| Martin, Victor, L,26885 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Zeng, Margaret, M,16191 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Martin, Ross,16201 | 3058.01 | 0.00 | 2181.56 | 0.00 | 876.45 |
| Goel, Gregory,28712 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Deng, Karla, C,29382 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Chen, Jessie,24069 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Romero, Diana,17760 | 92.25 | 0.00 | 0.00 | 0.00 | 92.25 |
| Fernandez, Jillian, K,12599 | 5649.21 | 0.00 | 0.00 | 2071.42 | 3577.79 |
| Smith, Destiny,22428 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Ramos, Darren,25470 | 162.99 | 0.00 | 0.00 | 0.00 | 162.99 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Walker, Madison,17105 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Ramos, Teresa,13689 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 2443.35 | 589.98 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 0.00 | 132.98 |
| Jimenez, Robyn, M,12861 | 4394.06 | 0.00 | 0.00 | 2049.10 | 2344.96 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Rai, Colin, W,24573 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
| Rodriguez, Marie, L,17960 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Luo, Arturo,22461 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Stewart, Megan, L,11413 | 7189.75 | 0.00 | 3399.99 | 0.00 | 3789.76 |
| Deng, Brad, D,20042 | 3150.40 | 699.10 | 0.00 | 0.00 | 2451.30 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Zhou, Curtis,25505 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 782.99 | 1758.95 |
| Guo, Clayton, J,22302 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Chander, Warren, A,17965 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Brianna, L,20558 | 3019.09 | 0.00 | 699.10 | 0.00 | 2319.99 |
| Rowe, Kristi, R,28692 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
Generated 2025-12-23 14:01:48.644 UTC