[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ ALL PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 86 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Hall, James,27202 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 |
| Rodriguez, Seth,14203 | 7081.46 | 0.00 | 0.00 | 2181.56 | 4899.90 |
| Andersen, Alvin, C,13744 | 2959.00 | 0.00 | 0.00 | 2959.00 | 0.00 |
| Lee, Miguel,12749 | 5915.54 | 0.00 | 3578.27 | 0.00 | 2337.27 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Perez, Maria, D,18072 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Julia, D,15013 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Allen, Fernando, H,16805 | 1768.96 | 0.00 | 0.00 | 1768.96 | 0.00 |
| Alvarez, Jésus, H,25569 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Simmons, Luke, J,16330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Cooper, Shelby,24740 | 96.07 | 0.00 | 0.00 | 0.00 | 96.07 |
| Young, Maria, J,18052 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| James, Xavier, C,28595 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Campbell, Elijah, R,25575 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Navarro, Desiree,15520 | 1611.96 | 0.00 | 0.00 | 782.99 | 828.97 |
| Schmidt, Stanley, C,19035 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Li, Jason,13729 | 4883.82 | 0.00 | 0.00 | 2443.35 | 2440.47 |
| Sanchez, Jesse, M,12623 | 5630.21 | 0.00 | 0.00 | 2049.10 | 3581.11 |
| Walker, Fernando, R,23302 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Yuan, Kathryn, L,23106 | 3956.01 | 0.00 | 0.00 | 2181.56 | 1774.45 |
| Wilson, Alexis, D,29217 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Nara, Melvin, E,27147 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Garcia, Michele,14980 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Phillips, Mary,22970 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Gill, Paula, W,28524 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Jenkins, Julia, R,19156 | 1728.27 | 0.00 | 0.00 | 0.00 | 1728.27 |
Generated 2025-12-24 06:27:30.049 UTC