[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 750 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 0.00 | 702.99 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 0.00 | 172.04 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 21.98 | 86.56 |
| Evans, Kaylee,19642 | 133.54 | 0.00 | 0.00 | 0.00 | 133.54 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Foster, Paige,27428 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 51.96 | 178.94 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 0.00 | 66.65 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 39.47 | 109.57 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Turner, James, E,16841 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Green, Gabriella, C,28035 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Evans, Jordan,29209 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 96.07 | 913.17 |
| Wright, Jennifer,26505 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 0.00 | 3118.60 |
| Martin, Christian, V,19709 | 197.25 | 0.00 | 0.00 | 0.00 | 197.25 |
Generated 2025-12-21 22:30:57.913 UTC