[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 1750 SHUFFLE
140 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rana, Lydia,29395 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Srini, Cesar,11563 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Ruiz, Briana,20906 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Gonzales, Isabella, R,14815 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rogers, Brianna,22536 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Andersen, Damien, K,29402 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Ortega, Jésus, L,16542 | 44.97 | 0.00 | 0.00 | 0.00 | 44.97 |
| Ruiz, Nelson,23638 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hall, Julia, R,27337 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Torres, Julio,22460 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Nath, Colleen,24051 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Weber, Stanley, E,12311 | 116.43 | 0.00 | 0.00 | 0.00 | 116.43 |
| Suarez, Felicia, W,28703 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Russell, Aaron,25599 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Chandra, Marie, A,25775 | 2451.30 | 0.00 | 0.00 | 0.00 | 2451.30 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Subram, Cynthia, A,20965 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Sanz, Jay,28503 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Wright, Elijah, I,25577 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gill, Julio, R,26993 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Martin, Teresa, D,22588 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Kumar, Dustin, R,26846 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Huang, Jeffery,25755 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Wu, Trisha,26404 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Sai, Jillian,22518 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Serrano, Ricky,27938 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mehta, George, L,20566 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| _SUM | 3388349.72 | 49631.45 | 559026.83 | 808170.26 | 1971521.18 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Tang, Gilbert, D,21533 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Gonzalez, Ruben, A,22468 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Andersen, Tamara, B,29392 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Lu, Colin, H,21069 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Moreno, Briana, L,28734 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Xu, Shaun, N,27804 | 53.98 | 0.00 | 0.00 | 0.00 | 53.98 |
| Clark, Marcus, G,27958 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shen, Damien, C,14964 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Rana, Brett, L,20943 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Raje, Damien, S,25784 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Perez, Meagan, R,21101 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Shan, Cristina,14783 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Zhao, Sandra, S,22503 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Sara, Erick, M,25448 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Li, Jorge, V,20133 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Mehta, Whitney, T,24197 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Kumar, Grant, A,25510 | 1212.95 | 0.00 | 0.00 | 0.00 | 1212.95 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sun, Alisha,18048 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| He, Arturo,29369 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Yang, Luke,28526 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Zhang, Jake,22616 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Kelly, Carlos, C,28561 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| He, Jenny, C,24100 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Fernandez, Harold, C,29359 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Lee, Emily,20585 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rodriguez, Dominic, E,28525 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Shan, Nichole, K,19461 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Perez, Francisco, M,17835 | 69.96 | 0.00 | 0.00 | 0.00 | 69.96 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ortega, Robyn,24104 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Holt, Katie,27946 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| She, Warren,21824 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Cox, Cole, M,25315 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Subram, Lydia, F,28549 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Pal, Damien, M,22566 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Gutierrez, Wendy,12610 | 101.95 | 0.00 | 0.00 | 0.00 | 101.95 |
| Alvarez, Ebony, M,28428 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Ramos, Linda,23598 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Gutierrez, Raquel, H,28697 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Malhotra, Troy,11569 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Sharma, Cassie, A,26978 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Vance, Martin, A,25604 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Liang, Mandy,28371 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Brown, Richard, M,29357 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Munoz, Meghan, P,27810 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Campbell, Andrea,25689 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Roberts, Dalton,26387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rubio, Byron,18622 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Rai, Barbara, J,22451 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Munoz, Arthur, L,22608 | 1744.97 | 0.00 | 0.00 | 0.00 | 1744.97 |
| Xu, Omar, R,19279 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Pal, Corey,25774 | 2537.32 | 0.00 | 0.00 | 0.00 | 2537.32 |
| Evans, Kyle,27890 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Lopez, James, E,20806 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Jai, Kate,14706 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Patel, Dominic,29366 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Ms., Sheperdigian, Janet,24541 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Yuan, Drew, R,21679 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Nara, Alisha, D,26959 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| She, Kara,23617 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Anderson, Benjamin,20809 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Black, Nicolas,23945 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-23 14:49:50.180 UTC