[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 112 >
112 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Goel, Warren, A,13678 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Rubio, Micheal, K,12622 | 5135.41 | 0.00 | 0.00 | 2049.10 | 3086.31 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Wilson, Jacob, H,15078 | 6675.60 | 0.00 | 3578.27 | 0.00 | 3097.33 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Rogers, Bryan,26890 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Butler, Eduardo, G,13533 | 137.94 | 0.00 | 0.00 | 0.00 | 137.94 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Xie, Mario,13687 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Hernandez, Naomi,25686 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Chande, Nina, D,19263 | 1587.41 | 0.00 | 0.00 | 1000.44 | 586.97 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gill, Craig, R,29379 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 782.99 | 1758.95 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, George, M,26359 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Gao, Autumn, W,24085 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Liu, Shannon, D,11250 | 7116.25 | 0.00 | 3399.99 | 0.00 | 3716.26 |
| Zhang, Arturo, V,26891 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 0.00 | 2181.56 | 2329.98 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Ms., Rockne, Carol Ann, F.,20164 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Torres, Nelson, F,25804 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| King, Thomas, M,29433 | 1289.33 | 0.00 | 0.00 | 0.00 | 1289.33 |
| Perez, Michele, K,13772 | 5928.25 | 0.00 | 3578.27 | 0.00 | 2349.98 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| King, Wyatt,22671 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Diaz, Kathleen, C,28375 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Prasad, Mayra,11238 | 7542.77 | 3399.99 | 0.00 | 2329.98 | 1812.80 |
| Wu, Rafael,12745 | 5199.72 | 0.00 | 0.00 | 2071.42 | 3128.30 |
| Raje, Kelsey, W,12227 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Nelson, Luke, E,21027 | 2537.97 | 0.00 | 0.00 | 782.99 | 1754.98 |
| Gutierrez, Raquel, H,28697 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Powell, Christian,19522 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Cook, Rachel, T,23614 | 144.45 | 0.00 | 0.00 | 0.00 | 144.45 |
| Alonso, Hector, L,12134 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Lal, Gilbert,24577 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Pal, Lindsey, A,21071 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Rai, Maurice, S,16328 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Rubio, Lance, E,19477 | 3533.77 | 0.00 | 0.00 | 3533.77 | 0.00 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
| Liu, Alan, V,16464 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Munoz, Danny,19355 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| _SUM | 3388349.72 | 49631.45 | 561208.39 | 805988.70 | 1971521.18 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Ortega, Robin,17798 | 3058.31 | 0.00 | 0.00 | 2443.35 | 614.96 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Morris, Olivia, L,14155 | 5993.26 | 0.00 | 3578.27 | 0.00 | 2414.99 |
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Li, Curtis, E,13692 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Fernandez, Heidi, L,22798 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Kumar, Arturo, W,24044 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Mitchell, Logan, R,16828 | 7182.66 | 0.00 | 0.00 | 2443.35 | 4739.31 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Tang, Kurt, G,13847 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Wood, Riley,14705 | 5875.55 | 0.00 | 3578.27 | 0.00 | 2297.28 |
| Sharma, Nicolas, D,13517 | 5666.38 | 0.00 | 0.00 | 2049.10 | 3617.28 |
| Ruiz, Roy, L,28704 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Black, Tara,24216 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Raji, Lindsay, E,22669 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Jai, April,15660 | 5169.07 | 0.00 | 3578.27 | 0.00 | 1590.80 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Navarro, Robin, J,28696 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Carlson, Jerome, J,21817 | 791.47 | 0.00 | 0.00 | 0.00 | 791.47 |
| Hughes, Adam,24546 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Luo, Alvin,23635 | 2452.34 | 0.00 | 0.00 | 2452.34 | 0.00 |
| Russell, Jason, A,27949 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Allen, Jada,26866 | 615.46 | 0.00 | 0.00 | 0.00 | 615.46 |
| Chandra, Mayra,16453 | 14.56 | 0.00 | 0.00 | 0.00 | 14.56 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raman, Joe, G,16511 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Jones, Lucas,27158 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Vance, Ebony,20724 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Yang, Bianca, E,28732 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Liu, Damien, M,17214 | 7211.39 | 0.00 | 0.00 | 2443.35 | 4768.04 |
| Mehta, Ronald, F,17649 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Raje, Yolanda,20852 | 2546.96 | 0.00 | 0.00 | 782.99 | 1763.97 |
| Sánchez, Cesar, W,23988 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Dominguez, Carolyn, F,22653 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Ruiz, Juan,28746 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sr., Cai, Ramón, S,16599 | 149.46 | 0.00 | 0.00 | 0.00 | 149.46 |
| Wu, Kelli, T,15621 | 5977.74 | 0.00 | 3578.27 | 0.00 | 2399.47 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 0.00 | 2443.35 | 799.48 |
| Dominguez, Ruben,16573 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Gill, Cheryl, R,28410 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 0.00 | 190.54 |
| Holt, Brittney,19523 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Chen, Tamara,12382 | 5606.26 | 0.00 | 0.00 | 2071.42 | 3534.84 |
| Sai, Tabitha,25741 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
Generated 2025-12-23 04:02:14.426 UTC