[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 958 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Lopez, Gabrielle, D,11311 | 77.27 | 0.00 | 0.00 | 74.98 | 2.29 |
| Cook, Alexa,12046 | 43.99 | 0.00 | 0.00 | 43.99 | 0.00 |
| Smith, Joshua, C,16362 | 2482.23 | 0.00 | 0.00 | 2482.23 | 0.00 |
| Collins, Natalie,17963 | 3932.54 | 0.00 | 0.00 | 2181.56 | 1750.98 |
| Huang, Trisha,11578 | 4406.39 | 0.00 | 0.00 | 4406.39 | 0.00 |
| Mehta, Candace,11588 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Luo, Katie, L,14498 | 3394.39 | 0.00 | 0.00 | 1000.44 | 2393.95 |
| Hill, Kevin, C,27547 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Rivera, Riley, T,17944 | 2751.42 | 0.00 | 0.00 | 1000.44 | 1750.98 |
| Navarro, Natasha,27570 | 4518.47 | 0.00 | 0.00 | 2071.42 | 2447.05 |
| Xie, Shawn, J,16476 | 4715.49 | 0.00 | 0.00 | 2181.56 | 2533.93 |
| Luo, Bridget, A,19503 | 1391.95 | 0.00 | 0.00 | 1391.95 | 0.00 |
| Kumar, Caleb, J,27558 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Wang, Logan, M,12150 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 |
| Johnson, Kaitlyn, L,15995 | 608.96 | 0.00 | 0.00 | 0.00 | 608.96 |
| Xie, Keith, W,24203 | 2469.05 | 0.00 | 0.00 | 0.00 | 2469.05 |
| Howard, Arianna, W,20743 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ms., Ward, Andrea,14595 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Natasha, G,16421 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Hayes, Fernando, G,22379 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Perry, Faith,16961 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Griffin, Katherine, P,27543 | 4468.16 | 0.00 | 0.00 | 2049.10 | 2419.06 |
| Carter, Gabrielle, B,16596 | 4486.54 | 0.00 | 0.00 | 2181.56 | 2304.98 |
| Richardson, Adrian, C,13984 | 3282.83 | 0.00 | 0.00 | 3282.83 | 0.00 |
| Wood, Jocelyn, E,27569 | 4464.48 | 0.00 | 0.00 | 2071.42 | 2393.06 |
| Srini, Erick, H,17947 | 3932.54 | 0.00 | 0.00 | 2181.56 | 1750.98 |
| Ye, Laura, J,12867 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Bailey, Abigail, E,27531 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
Generated 2024-09-21 13:50:30.237 UTC