[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Smith, Noah,13175 | 166.92 | 0.00 | 0.00 | 0.00 | 166.92 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 0.00 | 4719.02 |
| Gonzalez, Jeremiah,17468 | 128.91 | 0.00 | 0.00 | 0.00 | 128.91 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Rivera, Rachel, S,28996 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| Sanchez, Alex, K,13101 | 4736.03 | 0.00 | 0.00 | 0.00 | 4736.03 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Turner, Wyatt,20034 | 5769.96 | 0.00 | 3399.99 | 0.00 | 2369.97 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 0.00 | 200.73 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lu, Alejandro,25620 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Alexander, Thomas,20760 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 0.00 | 1290.33 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 0.00 | 557.54 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Rodriguez, Joshua, A,23511 | 4843.11 | 0.00 | 3578.27 | 0.00 | 1264.84 |
| Ramirez, Emma,29072 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 0.00 | 111.79 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| McDonald, Aaron, J,27734 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
Generated 2025-12-24 09:10:51.122 UTC