[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 719 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Shannon, W,24045 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Lori,18186 | 139.44 | 0.00 | 0.00 | 0.00 | 139.44 |
| Carlson, Melinda,20921 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Arthur, Carmen, M,12567 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Sai, Kaitlin, J,14529 | 254.06 | 0.00 | 0.00 | 0.00 | 254.06 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Felicia, R,14196 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Madan, Dominic, F,21847 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Suri, Michele,18007 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xie, Calvin, A,24858 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zimmerman, Curtis, T,14702 | 6729.57 | 0.00 | 3578.27 | 0.00 | 3151.30 |
| Malhotra, Ruth, D,16321 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Patel, Barry, J,26218 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Madan, Ross, C,27929 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Sanz, Frank, T,20851 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Torres, Juan, M,12746 | 105.24 | 0.00 | 0.00 | 0.00 | 105.24 |
| Deng, Nichole,19933 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Diaz, Reginald, A,24581 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Jenny, C,24100 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Lal, Johnny, G,12381 | 5161.73 | 0.00 | 0.00 | 2071.42 | 3090.31 |
| Navarro, Dwayne, H,11615 | 5205.71 | 0.00 | 0.00 | 2848.76 | 2356.95 |
| Bennett, Morgan,15097 | 8377.09 | 0.00 | 3578.27 | 0.00 | 4798.82 |
| Jenkins, Nathan, M,12286 | 5254.88 | 0.00 | 0.00 | 2049.10 | 3205.78 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
Generated 2025-12-23 07:42:53.599 UTC