[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1171 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Jorge, V,20133 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Dominguez, Victor, K,14784 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| He, Jenny, C,24100 | 1169.46 | 0.00 | 0.00 | 0.00 | 1169.46 |
| Hu, Steve, A,16294 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Zhu, Laura, M,29439 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Vazquez, Melinda, C,22553 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Suri, Veronica, D,23967 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Tasha,20565 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Guo, Clayton, J,22302 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Campbell, Andrea,25689 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Mitchell, Jose, F,24568 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Chandra, Whitney,15712 | 51.57 | 0.00 | 0.00 | 0.00 | 51.57 |
| Alvarez, Casey, A,28557 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Morgan, Taylor, M,24870 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Xie, Edwin, E,28879 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Raman, Douglas,24545 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Blanco, Pedro, C,26217 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gao, Sandra,12594 | 37.98 | 0.00 | 0.00 | 0.00 | 37.98 |
| Shen, Derek, T,22586 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Subram, Cindy, L,23943 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanz, Philip, J,17807 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Brooks, Sara, A,12288 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Goel, Tasha, R,19478 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gill, Lori, A,22510 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Campbell, Katherine, P,28448 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Schmidt, Meredith,25499 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Alonso, Francis, J,21738 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chapman, Joel,19050 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Sanchez, Heidi,28438 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Goel, Katrina,21682 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Tang, Lindsey, C,25308 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Roberts, Nathan,29470 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Jai, Kelvin,25796 | 2475.95 | 0.00 | 0.00 | 0.00 | 2475.95 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Alexander, Ana, R,22637 | 1714.97 | 0.00 | 0.00 | 0.00 | 1714.97 |
| Martin, Alexander, K,16402 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cook, Jade, C,25687 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 |
| Carlson, Desiree, V,14864 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Cai, Rosa,22618 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Moreno, Carrie, W,27151 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Nara, Terrence, R,28474 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Rai, Darrell, C,26906 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Johnsen, Jerome,28367 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Zhao, Rafael,13412 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Rivera, Dalton, E,28366 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Rubio, Rebekah,24699 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Romero, Eddie,28883 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Vazquez, Lance,11376 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| 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 |
| Vance, Francisco, A,20972 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Zhou, Damien,25776 | 2514.61 | 0.00 | 0.00 | 0.00 | 2514.61 |
| Guo, Brittney, B,22456 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Guo, Crystal,19379 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Schmidt, Billy,22434 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Romero, Jaime, B,28508 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Schmidt, Derrick, R,22605 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
Generated 2025-12-24 07:05:18.743 UTC