[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Brendan, L,14937 | 6652.89 | 0.00 | 3578.27 | 0.00 | 3074.62 |
| Wang, Lisa, J,17205 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Rana, Cesar, L,19044 | 29.93 | 0.00 | 0.00 | 0.00 | 29.93 |
| Lal, Nichole, P,25753 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Romero, Theodore,23747 | 1142.42 | 0.00 | 0.00 | 0.00 | 1142.42 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 4.99 | 85.48 |
| Alonso, Larry, B,13586 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Andersen, Nichole,12653 | 6860.09 | 0.00 | 0.00 | 2049.10 | 4810.99 |
| Nath, Chad,17744 | 2765.53 | 0.00 | 0.00 | 2181.56 | 583.97 |
| Navarro, Beth,13534 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Hill, Gabriella,26364 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raji, Edwin,11469 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 3033.33 | 0.00 |
| Prasad, Jillian,12860 | 4464.09 | 0.00 | 0.00 | 2049.10 | 2414.99 |
| Ye, Rosa, C,19940 | 3440.43 | 0.00 | 0.00 | 1000.44 | 2439.99 |
| Lee, Jacob,13551 | 5622.92 | 0.00 | 0.00 | 2049.10 | 3573.82 |
| Rubio, Ross,21540 | 1602.47 | 0.00 | 0.00 | 782.99 | 819.48 |
| Blanco, Jacquelyn,13411 | 6819.46 | 0.00 | 0.00 | 2071.42 | 4748.04 |
| Raman, Bryant, S,19048 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Gonzales, Katherine, R,13408 | 6792.12 | 0.00 | 0.00 | 2049.10 | 4743.02 |
| Rogers, Christina, F,21668 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Rana, Cassandra,13407 | 6904.10 | 0.00 | 0.00 | 2049.10 | 4855.00 |
| Patel, Joel,27820 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Gill, Philip,22599 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Alonso, Albert, M,17645 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Raji, Cristina, E,25506 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Romero, Neil,28424 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Gonzalez, Preston, L,14156 | 229.57 | 0.00 | 0.00 | 33.98 | 195.59 |
| Raji, Jenny,21870 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Martinez, Deanna,17202 | 6974.06 | 0.00 | 0.00 | 2181.56 | 4792.50 |
| Dominguez, Clinton,15933 | 6931.88 | 0.00 | 2181.56 | 0.00 | 4750.32 |
| Vance, Veronica, G,16575 | 6994.57 | 0.00 | 0.00 | 2181.56 | 4813.01 |
| Patel, Bruce,27165 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Anand, Tonya, A,27141 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Moyer, Philip, M,16386 | 129.95 | 0.00 | 0.00 | 0.00 | 129.95 |
| Martinez, Brandy, L,12865 | 114.23 | 0.00 | 0.00 | 0.00 | 114.23 |
| Prasad, Mayra,11238 | 7542.77 | 3399.99 | 0.00 | 3579.82 | 562.96 |
| Howard, Makayla,16251 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Zhu, Valerie, M,13599 | 51.25 | 0.00 | 0.00 | 0.00 | 51.25 |
| Kelly, Olivia, L,12391 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Zhang, Candice, J,23777 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Dominguez, Lori,12648 | 6817.60 | 0.00 | 0.00 | 2049.10 | 4768.50 |
| Fernandez, Clifford, E,21026 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Kennedy, Kelsey, M,23984 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Raji, Franklin,11400 | 6967.78 | 0.00 | 3374.99 | 2318.96 | 1273.83 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Zeng, Randy, A,11341 | 8192.00 | 0.00 | 3399.99 | 2338.97 | 2453.04 |
| Beck, Carl, M,16311 | 2988.32 | 0.00 | 2181.56 | 806.76 | 0.00 |
| Adams, Rebecca, F,17644 | 3017.33 | 0.00 | 0.00 | 3017.33 | 0.00 |
| Townsend, Roberto,19359 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Rodriguez, Deanna,25611 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| Rai, Kelsey, L,19437 | 3480.38 | 0.00 | 0.00 | 3480.38 | 0.00 |
| Luo, Dale, M,22613 | 1183.47 | 0.00 | 0.00 | 1183.47 | 0.00 |
| Goel, Latoya, C,11239 | 7511.55 | 3374.99 | 0.00 | 2353.95 | 1782.61 |
| Kovár, Abby, K,25605 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Raje, Bridget, A,19433 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Hernandez, Adrienne, Y,22668 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Nath, Casey,11616 | 5253.65 | 0.00 | 2071.42 | 784.28 | 2397.95 |
| Rodriguez, Ann, S,12315 | 6803.13 | 0.00 | 0.00 | 6803.13 | 0.00 |
Generated 2025-11-03 15:18:45.021 UTC