[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Torres, Rodney, L,22520 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Goel, Warren, A,13678 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Chen, Krystal, D,13530 | 186.28 | 0.00 | 0.00 | 0.00 | 186.28 |
| Suri, Cynthia,22589 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Cara,11350 | 38.47 | 0.00 | 0.00 | 38.47 | 0.00 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hernandez, Gerald, L,24054 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Wu, Roger,22630 | 1164.47 | 0.00 | 0.00 | 1164.47 | 0.00 |
| Lopez, Geoffrey, A,29451 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gao, Mandy, M,12560 | 5636.90 | 0.00 | 0.00 | 2049.10 | 3587.80 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Wagner, Clayton, L,20922 | 3226.34 | 0.00 | 0.00 | 782.99 | 2443.35 |
| Morris, Savannah,13585 | 8368.29 | 3578.27 | 0.00 | 0.00 | 4790.02 |
| James, Arianna, A,25799 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Foster, Jordan, M,20807 | 3249.31 | 0.00 | 0.00 | 782.99 | 2466.32 |
| Arun, Rachael, J,23976 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perry, Hailey, G,20721 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Mrs., West, Alyssa,23219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Teresa, L,16946 | 3071.03 | 0.00 | 0.00 | 2181.56 | 889.47 |
| Kapoor, Sergio, E,19392 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Gonzalez, Troy, A,28517 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Suarez, Clinton,22657 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Lawrence, C,17225 | 6986.87 | 0.00 | 0.00 | 2181.56 | 4805.31 |
| Price, Brittany,12492 | 5166.41 | 0.00 | 0.00 | 2049.10 | 3117.31 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Foster, Isabella,27892 | 649.46 | 0.00 | 0.00 | 0.00 | 649.46 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Goel, Sharon, M,19430 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Chandra, Bruce, H,14970 | 158.96 | 0.00 | 0.00 | 0.00 | 158.96 |
| Zeng, Todd, C,12283 | 5582.91 | 0.00 | 0.00 | 3272.94 | 2309.97 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Luo, Arturo,22461 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Goel, Gregory,28712 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Dominguez, Deanna,23779 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Shan, Lindsay,27186 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Subram, Sergio,28386 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Madan, Joel, C,17887 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raje, Tamara, J,19946 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Reed, Taylor,23983 | 1195.47 | 0.00 | 0.00 | 0.00 | 1195.47 |
| Subram, Cynthia, A,20965 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Griffin, Ashley,24865 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Ruiz, Janet, M,22818 | 56.96 | 0.00 | 0.00 | 56.96 | 0.00 |
| Nath, Clarence,24050 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Mr., Thompson, Austin,12513 | 241.76 | 0.00 | 0.00 | 0.00 | 241.76 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Ruiz, Derrick, C,12634 | 6787.76 | 0.00 | 0.00 | 2071.42 | 4716.34 |
| Deng, Chad,22611 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Patel, Cassandra, P,12465 | 83.42 | 0.00 | 0.00 | 0.00 | 83.42 |
Generated 2025-12-22 03:30:04.834 UTC