[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1016 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bailey, Zoe, L,15554 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Tang, Priscilla, J,12479 | 4401.41 | 0.00 | 0.00 | 2071.42 | 2329.99 |
| Patterson, Tristan,27088 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Wright, Jose,12022 | 136.25 | 0.00 | 0.00 | 0.00 | 136.25 |
| Chander, Sharon,25607 | 1253.32 | 0.00 | 0.00 | 0.00 | 1253.32 |
| Gray, Isaac, G,12373 | 2359.46 | 0.00 | 0.00 | 0.00 | 2359.46 |
| Anderson, Brianna, R,19818 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Liu, Ramon, M,17618 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Miguel, R,16900 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Allen,19386 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Gray, Chase, J,15688 | 6221.52 | 0.00 | 0.00 | 2181.56 | 4039.96 |
| Lewis, Natalie, E,27079 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Navarro, Jésus, L,29483 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Scott, Nathan, K,13887 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
| Xu, Leonard, D,16051 | 2746.55 | 0.00 | 0.00 | 2181.56 | 564.99 |
| Flores, Spencer,27095 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Anderson, Dalton, A,19188 | 2732.70 | 0.00 | 0.00 | 1000.44 | 1732.26 |
| Zhang, Clayton,29482 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Miller, Lucas, L,12495 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Suarez, Lori,12484 | 4441.04 | 0.00 | 0.00 | 2049.10 | 2391.94 |
| Nara, Nicolas, M,20861 | 2368.06 | 0.00 | 0.00 | 782.99 | 1585.07 |
| Martin, Alexandra, C,27093 | 4509.48 | 0.00 | 0.00 | 2071.42 | 2438.06 |
| James, Kaitlyn, I,15562 | 1347.97 | 0.00 | 0.00 | 1347.97 | 0.00 |
| Watson, Chase,27096 | 4490.48 | 0.00 | 0.00 | 2071.42 | 2419.06 |
| Pal, Mario, C,17824 | 4334.61 | 0.00 | 0.00 | 2443.35 | 1891.26 |
| Miller, Daniel, V,27193 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Moreno, Ricky, R,17775 | 2793.91 | 0.00 | 0.00 | 1000.44 | 1793.47 |
| Young, Rebecca, W,14418 | 1928.93 | 0.00 | 0.00 | 1000.44 | 928.49 |
| Lu, Ernest, H,14417 | 1848.91 | 0.00 | 0.00 | 1000.44 | 848.47 |
| Coleman, Kelly,15769 | 3159.95 | 0.00 | 0.00 | 782.99 | 2376.96 |
Generated 2025-12-24 06:34:38.135 UTC