[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jenkins, Blake,28907 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Shan, Bonnie,12329 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Lal, Ricardo, C,17958 | 2811.52 | 0.00 | 0.00 | 2181.56 | 629.96 |
| Yang, Ramon, K,13609 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Long, Kelly, G,25545 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 0.00 | 132.98 |
| Nath, Colin, N,11398 | 8114.04 | 0.00 | 3399.99 | 0.00 | 4714.05 |
| Lin, Candice, K,19506 | 3480.38 | 0.00 | 0.00 | 1000.44 | 2479.94 |
| Cooper, Kimberly, J,22457 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Morris, Jacqueline, H,29468 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Andersen, Dale, B,14992 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lal, Misty, L,22385 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hall, Destiny, G,25615 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Deng, Raul, D,16272 | 3021.04 | 0.00 | 0.00 | 2181.56 | 839.48 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Sanz, Ebony, I,20711 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Zeng, Valerie,17977 | 2966.03 | 0.00 | 0.00 | 2181.56 | 784.47 |
| Lal, Tony,28515 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Griffin, Ashley,24865 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Ward, Marcus, L,19511 | 3524.36 | 0.00 | 0.00 | 1000.44 | 2523.92 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Shan, Willie,17098 | 2768.53 | 0.00 | 0.00 | 2768.53 | 0.00 |
| Li, Laura, O,20933 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Rodriguez, Stefanie, L,12459 | 5618.54 | 0.00 | 0.00 | 2071.42 | 3547.12 |
| Rubio, Jill,13838 | 140.55 | 0.00 | 0.00 | 0.00 | 140.55 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Sanz, Juan, R,14983 | 71.27 | 0.00 | 0.00 | 0.00 | 71.27 |
| Rana, Marie, A,27308 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rai, Dale, E,21739 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Patel, Joel,27820 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Rai, Maurice, S,16328 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Goel, Tracy, J,18178 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Raje, Yolanda,20852 | 2546.96 | 0.00 | 0.00 | 782.99 | 1763.97 |
| Carlson, Arthur, P,11343 | 8221.99 | 0.00 | 3399.99 | 0.00 | 4822.00 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Martinez, Jarrod, H,22313 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kapoor, Marco,19512 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Gonzalez, Rachael, M,23636 | 2479.94 | 0.00 | 0.00 | 0.00 | 2479.94 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Wu, Rosa,16461 | 3287.32 | 0.00 | 0.00 | 2443.35 | 843.97 |
| Lu, Rafael, J,22869 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Anna,14817 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Alvarez, Robin, V,11243 | 7164.25 | 0.00 | 3399.99 | 2364.98 | 1399.28 |
| Ms., Smith, Mary, J.,28437 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| She, Terry, R,25454 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Richardson, Ian,11414 | 7191.77 | 0.00 | 3399.99 | 0.00 | 3791.78 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Rodriguez, Bruce,28473 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sara, Arthur, D,23753 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Shan, Jerry,19382 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Sai, Stanley,13675 | 215.23 | 0.00 | 0.00 | 0.00 | 215.23 |
| Griffin, Jeremiah,18158 | 6869.61 | 0.00 | 0.00 | 2181.56 | 4688.05 |
| Chander, Jenny, A,19917 | 3369.41 | 0.00 | 0.00 | 1000.44 | 2368.97 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Kumar, Dustin, R,26846 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Roberts, Mackenzie,23599 | 42.93 | 0.00 | 0.00 | 0.00 | 42.93 |
| Xu, Karen, E,17115 | 3008.02 | 0.00 | 0.00 | 2181.56 | 826.46 |
| Thompson, Morgan, Q,24011 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Blanco, Joe,25675 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Gutierrez, Kristy,24138 | 1194.97 | 0.00 | 0.00 | 0.00 | 1194.97 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Munoz, Lori, M,22639 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Vance, Kaitlin,29383 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Thompson, Noah, L,14547 | 192.95 | 0.00 | 0.00 | 0.00 | 192.95 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lee, Hannah, F,15713 | 37.59 | 0.00 | 0.00 | 0.00 | 37.59 |
| Rana, Lydia,29395 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Lopez, Cindy, L,27137 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Prasad, Veronica, J,24199 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sharma, Nichole, M,14692 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Subram, Lydia, F,28549 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Rai, Donna,12235 | 62.76 | 0.00 | 0.00 | 0.00 | 62.76 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Garcia, Tammy, A,12293 | 86.76 | 0.00 | 0.00 | 0.00 | 86.76 |
| Jai, Grant,24200 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raje, Melvin,11580 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sun, Omar, D,25783 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xie, Carl, R,18136 | 6904.60 | 0.00 | 0.00 | 2181.56 | 4723.04 |
| Kelly, Brianna, C,16945 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Dominguez, Jésus,17087 | 75.21 | 0.00 | 0.00 | 0.00 | 75.21 |
| Diaz, Jaime, A,17795 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Sai, Jillian,22518 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Becker, Kate,16447 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| Bailey, Garrett,19055 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 782.99 | 1775.47 |
| Adams, Rebecca, F,17644 | 3017.33 | 0.00 | 0.00 | 3017.33 | 0.00 |
| Butler, Kayla, J,25748 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Wu, Jake, E,22446 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| She, Todd,23442 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Armando, P,17978 | 3018.01 | 0.00 | 0.00 | 2181.56 | 836.45 |
| Ramos, Daisy,14552 | 103.97 | 0.00 | 0.00 | 0.00 | 103.97 |
| Coleman, Jessica,13553 | 5603.24 | 0.00 | 0.00 | 2071.42 | 3531.82 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
Generated 2025-12-22 05:39:32.095 UTC