[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rivera, Chase,28511 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Carlson, Gloria, P,15632 | 5245.06 | 0.00 | 3578.27 | 0.00 | 1666.79 |
| Lopez, Michele, C,21509 | 3117.96 | 0.00 | 0.00 | 782.99 | 2334.97 |
| Rana, Carolyn,21829 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Mr., Rodman, Jim,20562 | 2994.09 | 0.00 | 699.10 | 0.00 | 2294.99 |
| Gomez, Neil,29426 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Taylor, Charles,13792 | 7216.08 | 0.00 | 3578.27 | 0.00 | 3637.81 |
| Sanchez, Gerald,24144 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Luo, Arturo,22461 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Vazquez, Lance,11376 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Tang, Devon, L,24132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shan, Sharon, A,24211 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Romero, Diana,17760 | 92.25 | 0.00 | 0.00 | 0.00 | 92.25 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 0.00 | 4737.02 |
| Mitchell, Logan, R,16828 | 7182.66 | 0.00 | 0.00 | 2443.35 | 4739.31 |
| Alvarez, Neil, C,22467 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Davis, Lucas, S,19378 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Hernandez, Tyrone, C,12271 | 5683.18 | 0.00 | 0.00 | 3340.26 | 2342.92 |
| Williams, Abigail, M,16938 | 3110.05 | 0.00 | 0.00 | 2181.56 | 928.49 |
| Prasad, Rebekah, A,15919 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Goel, Kathryn,12740 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Pal, Jon, H,15440 | 6736.56 | 0.00 | 3578.27 | 0.00 | 3158.29 |
| Samant, Mandar,12873 | 5676.24 | 0.00 | 0.00 | 2071.42 | 3604.82 |
| Price, Brittany,12492 | 5166.41 | 0.00 | 0.00 | 2049.10 | 3117.31 |
| Zhang, Trisha,18156 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Deng, Lindsay, K,29447 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Shan, Grant,26215 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ross, Hailey, C,13612 | 83.95 | 0.00 | 0.00 | 0.00 | 83.95 |
| Wu, Susan, L,16564 | 132.27 | 0.00 | 0.00 | 0.00 | 132.27 |
| Taylor, Joseph, T,12289 | 5645.86 | 0.00 | 0.00 | 2049.10 | 3596.76 |
Generated 2025-12-21 16:41:29.097 UTC