[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jenkins, Devin,22383 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Patel, Ebony,25531 | 1188.46 | 0.00 | 0.00 | 0.00 | 1188.46 |
| Moreno, Raquel, D,25637 | 2510.94 | 0.00 | 0.00 | 0.00 | 2510.94 |
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Randall, Kristi,13665 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Suarez, Max, A,14809 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| He, Rosa, J,15638 | 5162.37 | 0.00 | 3578.27 | 0.00 | 1584.10 |
| Navarro, Lawrence,27939 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Sandoval, Jill,14143 | 90.58 | 0.00 | 0.00 | 0.00 | 90.58 |
| Prasad, Rebekah, A,15919 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Mehta, Ivan, S,26390 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Nath, Katrina, R,11497 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Subram, Allen,17895 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Madan, Troy,25467 | 1151.76 | 0.00 | 0.00 | 0.00 | 1151.76 |
| Sanz, Frank, T,20851 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Srini, Brett, D,25553 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Sharma, Nichole, M,14692 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Deng, Yolanda,28427 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Patel, Manuel, M,20889 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| She, Deborah,25576 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Blanco, Jaime,22528 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mr., Sneath, Timothy,17708 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Travers, Micheal,26397 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Martinez, Deanna,17202 | 6974.06 | 0.00 | 0.00 | 2181.56 | 4792.50 |
| Martinez, Evelyn, J,17204 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Perry, Sydney, C,14963 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Terrance, C,21046 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Li, Leah,12871 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Kovar, Shane, L,12294 | 75.48 | 0.00 | 0.00 | 0.00 | 75.48 |
| Gill, Kristi, A,27171 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Jimenez, Michele,13547 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Vazquez, Theodore, T,16831 | 7206.37 | 0.00 | 0.00 | 2443.35 | 4763.02 |
| Wang, Kyle,20599 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Liang, Jessie,19513 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Vance, Meagan, F,29405 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Henderson, Tristan,12224 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Anand, Lindsey, K,22592 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Dominguez, Lori,12648 | 6817.60 | 0.00 | 0.00 | 2049.10 | 4768.50 |
| Xie, Katie, C,19916 | 3354.39 | 0.00 | 0.00 | 1000.44 | 2353.95 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| Subram, Holly, J,28552 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Xu, Shawn,19328 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Raje, Christine, W,17203 | 6952.53 | 0.00 | 0.00 | 2181.56 | 4770.97 |
| Sharma, Nina,23760 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Raji, Marshall, L,27175 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Gao, Jessie,20564 | 3059.08 | 0.00 | 699.10 | 0.00 | 2359.98 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Sanz, Robin, L,15087 | 5917.24 | 0.00 | 3578.27 | 0.00 | 2338.97 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Prasad, Martin,15089 | 5895.24 | 0.00 | 3578.27 | 0.00 | 2316.97 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 2429.46 | 1263.82 |
| Subram, Levi,15619 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Goel, Deborah, S,11489 | 8127.51 | 0.00 | 3374.99 | 2359.46 | 2393.06 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Perez, Andre,11491 | 8158.01 | 0.00 | 3374.99 | 2329.98 | 2453.04 |
| Smith, Ethan,14530 | 72.86 | 0.00 | 0.00 | 36.59 | 36.27 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Lopez, Cindy, L,27137 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Robinson, Brandon, J,15661 | 5208.04 | 0.00 | 3578.27 | 0.00 | 1629.77 |
| Deng, Shawn, C,16590 | 168.95 | 0.00 | 0.00 | 0.00 | 168.95 |
| Luo, Calvin, T,19172 | 1609.41 | 0.00 | 1000.44 | 0.00 | 608.97 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 2343.96 | 2393.06 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 42.97 | 14.98 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Patel, Stefanie,27967 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 2319.99 | 2398.05 |
| Jai, Shawna, W,17750 | 2888.53 | 0.00 | 0.00 | 2181.56 | 706.97 |
| Torres, Deb,11550 | 5241.43 | 0.00 | 2049.10 | 3192.33 | 0.00 |
| Washington, Haley, F,23904 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Deng, Tonya, O,17936 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Xie, Terry,20885 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Zhou, Lisa, L,13809 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Sara, Henry, L,20892 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sai, Sergio,12473 | 5665.22 | 0.00 | 0.00 | 2071.42 | 3593.80 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Evans, Lucas, J,11556 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Tang, Bonnie, W,27856 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Anand, Colleen, N,12647 | 6886.60 | 0.00 | 0.00 | 2049.10 | 4837.50 |
| Rai, Cassie, R,14194 | 168.93 | 0.00 | 0.00 | 68.97 | 99.96 |
| Raman, Francisco, M,24020 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Moreno, Briana, L,28734 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chander, Peter, L,14836 | 115.25 | 0.00 | 0.00 | 78.98 | 36.27 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Martin, Paula, B,21855 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Vance, Erick,28742 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Martinez, Andre,16588 | 6994.58 | 0.00 | 0.00 | 2181.56 | 4813.02 |
| Raje, Roger, E,11596 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Cox, Melanie, C,12496 | 204.58 | 0.00 | 0.00 | 0.00 | 204.58 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Srini, Martin, L,18629 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Tang, Brad,25489 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Kapoor, George, L,13676 | 68.87 | 0.00 | 0.00 | 36.27 | 32.60 |
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Alvarez, Roberto,28387 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Hu, Candice,27818 | 607.96 | 0.00 | 0.00 | 0.00 | 607.96 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Lopez, Carolyn, L,25668 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Liang, Clayton, E,14958 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Zhao, Kelli,26386 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Torres, Lawrence,15671 | 31.55 | 0.00 | 0.00 | 7.28 | 24.27 |
| Malhotra, Raymond, T,13251 | 6844.42 | 0.00 | 0.00 | 2049.10 | 4795.32 |
| Alvarez, Ebony, M,28428 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Alonso, Felicia, A,26842 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nara, Louis, J,26901 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Navarro, Wendy, C,20881 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Ye, Randy, G,29367 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lu, Erica,27009 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
Generated 2025-11-02 11:25:10.503 UTC