[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Butler, Zachary,22052 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Williams, Nicole, J,18384 | 103.48 | 0.00 | 0.00 | 103.48 | 0.00 |
| Nath, Misty, E,24141 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Hill, Wyatt, L,11016 | 2332.28 | 0.00 | 0.00 | 2332.28 | 0.00 |
| Martinez, Devin, J,11675 | 5898.26 | 0.00 | 3578.27 | 2319.99 | 0.00 |
| Henderson, Oscar, J,15852 | 3222.98 | 0.00 | 0.00 | 782.99 | 2439.99 |
| Alonso, Jon,25952 | 4598.83 | 0.00 | 3374.99 | 0.00 | 1223.84 |
| Thompson, Charles, J,13724 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 |
| Perry, Jason, M,24325 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Walker, Christian,11855 | 89.98 | 0.00 | 0.00 | 0.00 | 89.98 |
| Garcia, Brianna, E,21626 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Jenkins, Julia, R,19156 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
| Brown, Seth, A,14731 | 2435.08 | 0.00 | 699.10 | 0.00 | 1735.98 |
| Shan, Jodi, A,15095 | 7255.66 | 0.00 | 0.00 | 2443.35 | 4812.31 |
| Navarro, Danny, J,20332 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Xu, Candice, W,27324 | 2364.97 | 0.00 | 0.00 | 0.00 | 2364.97 |
| Deng, Shaun,13572 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Jimenez, Ebony,14834 | 4397.75 | 0.00 | 3578.27 | 0.00 | 819.48 |
| Gonzalez, Terrance, B,21833 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Brooks, Garrett, L,18425 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Brown, Lucas,19816 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Mr., Seamans, Mike,16130 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Long, Hannah, E,11157 | 41.28 | 0.00 | 0.00 | 0.00 | 41.28 |
| Perez, Katelyn, K,11656 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Scott, Jeremiah,19402 | 1254.47 | 0.00 | 0.00 | 1254.47 | 0.00 |
| Rana, Carmen, A,14940 | 8367.55 | 0.00 | 3578.27 | 2419.06 | 2370.22 |
| Peterson, Catherine,25156 | 36.59 | 0.00 | 0.00 | 36.59 | 0.00 |
| Baker, Morgan,18833 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Ortega, Kristy, E,20063 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Russell, Caroline, L,11130 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
Generated 2024-11-10 17:37:15.166 UTC