[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 979 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Rodriguez, Carolyn,21002 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Chandra, Brenda,15100 | 6952.58 | 0.00 | 2181.56 | 2419.06 | 2351.96 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 32.27 | 189.96 |
| Jackson, Chloe, J,23864 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Zhu, Eugene, D,13060 | 2808.00 | 0.00 | 2181.56 | 626.44 | 0.00 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 0.00 | 141.83 |
| Alonso, Joe, F,28766 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Wood, Nicole,16010 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Raman, Ruth, L,21199 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Bryant, Blake, C,15202 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Watson, Amanda, A,14358 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Hernandez, Luke,13931 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Xu, Darryl,19931 | 3125.91 | 0.00 | 782.99 | 0.00 | 2342.92 |
| Yang, Tiffany, K,21215 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Hu, Omar, S,28954 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Henderson, Natalie,19273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mitchell, Kaitlyn, D,18130 | 5743.97 | 0.00 | 1000.44 | 0.00 | 4743.53 |
| Suarez, Wendy,22511 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Lin, Erica, E,16033 | 3743.39 | 0.00 | 2181.56 | 0.00 | 1561.83 |
| Foster, Julia, A,26238 | 3298.94 | 0.00 | 2049.10 | 0.00 | 1249.84 |
| Harui, Roger,11509 | 196.29 | 0.00 | 0.00 | 0.00 | 196.29 |
| Adams, Luis, R,22517 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Diaz, Jonathan, K,13190 | 4501.55 | 0.00 | 2181.56 | 0.00 | 2319.99 |
| Huang, Edwin,15195 | 3154.95 | 0.00 | 782.99 | 0.00 | 2371.96 |
| Schmidt, Ruth, L,28506 | 3213.57 | 0.00 | 2049.10 | 0.00 | 1164.47 |
| Bryant, Antonio, R,13016 | 4813.32 | 0.00 | 2443.35 | 0.00 | 2369.97 |
Generated 2024-11-11 01:49:47.774 UTC