[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 1750
140 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gutierrez, Arthur, A,12504 | 61.08 | 0.00 | 0.00 | 0.00 | 61.08 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Madan, Phillip,27162 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Smith, Ethan,14530 | 72.86 | 0.00 | 0.00 | 0.00 | 72.86 |
| Dominguez, Jay, A,21857 | 2487.33 | 0.00 | 0.00 | 2487.33 | 0.00 |
| Perez, Meredith, A,23597 | 2482.23 | 0.00 | 0.00 | 2482.23 | 0.00 |
| Rana, Tabitha, Y,16601 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Stone, Brent,22811 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Sanz, Jaime, C,19928 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Shan, Alicia,27964 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Lopez, Bryant,24218 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alvarez, Theodore,25690 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lopez, Janelle, G,25500 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Suarez, Albert, W,20950 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Navarro, Arthur,16198 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Dominguez, Albert,27125 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Ortega, Walter,28377 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Thomas, Miguel,25480 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Zheng, Trisha,22437 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Henderson, Alexandria, R,11555 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Holt, Katie,27946 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Arun, Roy, W,23620 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Young, Henry,12403 | 67.27 | 0.00 | 0.00 | 0.00 | 67.27 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| He, Claudia, F,24093 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Luo, Tony, W,29423 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Tang, Alejandro, L,11542 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Rubio, Casey, A,24152 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Xu, Jodi,16460 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Garcia, Kristina,25446 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Luo, Sharon, D,11553 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Lal, Alvin,24058 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Gonzalez, Eduardo,27132 | 571.72 | 0.00 | 0.00 | 0.00 | 571.72 |
| Gray, Devin,16584 | 172.95 | 0.00 | 0.00 | 39.98 | 132.97 |
| Torres, Janet, J,23985 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Maurice,26929 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Diaz, Billy,21839 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| Kumar, Nichole,23236 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Carlson, Joe, L,25627 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Miller, Grace,22502 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Black, Tamara, L,24202 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Sharma, Lacey, M,29472 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Martinez, Michele, L,19247 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Jai, Kelsey, J,27837 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| She, Cara, H,22646 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Martin, Albert,26837 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Blanco, Jill,17838 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Arun, Meagan, W,23930 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Chander, Kelli,26934 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gonzalez, Raymond, P,28755 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Gutierrez, Jésus, E,16437 | 47.26 | 0.00 | 0.00 | 0.00 | 47.26 |
| Raji, Tommy,25636 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Cox, Andrea,13830 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Romero, Jaime, B,28508 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Simmons, Wyatt, V,22604 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Sun, Alejandro, B,23923 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Suri, Dominique,25584 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gray, Allison, D,20571 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Vazquez, Carrie,29419 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Blanco, Beth,29444 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| She, Gilbert,19505 | 53.47 | 0.00 | 0.00 | 0.00 | 53.47 |
| Rana, Kristina,27847 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Ruiz, Neil, N,29477 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Ramos, Tabitha,20147 | 37.97 | 0.00 | 0.00 | 0.00 | 37.97 |
| Guo, Stacey,24207 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Steven,16435 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Guo, Dawn, R,25603 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Rai, Darrell, C,26906 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Zheng, Nuan,13604 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Randall, Mayra,27909 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Xie, Melvin,28426 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Coleman, Christian,25798 | 2452.34 | 0.00 | 0.00 | 0.00 | 2452.34 |
| Raman, Holly,25477 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Robinson, Jasmine,26886 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Chandra, Summer, D,24880 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suarez, Sheila,28884 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Srini, Ronald, E,16467 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Ian, C,29422 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Ruiz, Ruben, A,20055 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Carlson, Darren, D,29478 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martinez, Francisco,11375 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Lopez, Martin, E,21864 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Dominguez, Natasha,23769 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Sanz, Erika, J,22670 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Clark, Devin,25512 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Lopez, Cassandra,22308 | 1768.96 | 0.00 | 0.00 | 0.00 | 1768.96 |
| Xie, Katrina, M,26897 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Tang, Gilbert, D,21533 | 40.22 | 0.00 | 0.00 | 0.00 | 40.22 |
| Li, Jorge, V,20133 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Yang, Luke,28526 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rubio, Dwayne, D,28527 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Mehta, George, L,20566 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Zhao, Amy, C,26416 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Subram, Lydia, F,28549 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Zhu, Stacey, E,22636 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Zhao, Omar,27927 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Bryant, Ian,27319 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Anderson, Kaitlyn, H,24101 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 0.00 | 70.24 |
| Coleman, Austin, V,14865 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Sun, Brent,25585 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Wang, Dawn, L,27152 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Suri, Tabitha,27957 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Bradley, Isabel,27783 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| _SUM | 3388349.72 | 49631.45 | 561208.39 | 810781.72 | 1966728.16 |
Generated 2025-12-22 02:23:28.074 UTC