[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 986 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| King, Jackson, E,18067 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Long, Spencer, W,17424 | 2423.48 | 0.00 | 0.00 | 0.00 | 2423.48 |
| Peterson, Sean, R,17140 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Flores, Isabel,23715 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| 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 |
| Griffin, Alexia, W,18027 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Wright, Nathan, D,15984 | 3124.96 | 0.00 | 0.00 | 782.99 | 2341.97 |
| Li, Colleen, H,16569 | 3936.54 | 0.00 | 0.00 | 3936.54 | 0.00 |
| Edwards, James, K,27508 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Rubio, Darren,16548 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Rubio, Craig,16937 | 3926.53 | 0.00 | 0.00 | 3926.53 | 0.00 |
| Watson, Jennifer, H,15965 | 3108.95 | 0.00 | 0.00 | 782.99 | 2325.96 |
| Gonzalez, Edward,15968 | 3099.96 | 0.00 | 0.00 | 782.99 | 2316.97 |
| Cooper, Gabriella, L,18596 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Suarez, Lee, D,22680 | 620.95 | 0.00 | 0.00 | 0.00 | 620.95 |
| Patterson, Marcus, D,23843 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Williams, Kaitlyn, A,19221 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Harris, Marcus, L,11135 | 2334.97 | 0.00 | 0.00 | 2334.97 | 0.00 |
| Thomas, Hunter,22863 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Adams, Luis, R,22517 | 562.96 | 0.00 | 0.00 | 562.96 | 0.00 |
| Lal, Sharon, L,17891 | 2736.42 | 0.00 | 0.00 | 1000.44 | 1735.98 |
| Weber, Tammy, A,17998 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sai, Cindy, E,11547 | 4976.38 | 0.00 | 0.00 | 4401.40 | 574.98 |
Generated 2024-09-21 11:31:33.877 UTC