[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 156 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 69.97 | 79.87 |
| Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Long, Gabrielle,19830 | 5765.92 | 3374.99 | 0.00 | 0.00 | 2390.93 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Jordyn, K,15391 | 4828.01 | 0.00 | 0.00 | 0.00 | 4828.01 |
| Jenkins, Gabrielle, B,21659 | 4143.74 | 3578.27 | 0.00 | 0.00 | 565.47 |
| Prasad, Molly,24392 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 603.49 | 0.00 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Green, Sophia, E,24977 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Price, Jocelyn, D,25875 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Clark, Anthony,27071 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Young, Savannah,25971 | 2749.32 | 0.00 | 2181.56 | 0.00 | 567.76 |
| Harris, Edward,27062 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Perry, Olivia,20375 | 4438.38 | 0.00 | 0.00 | 2071.42 | 2366.96 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 0.00 | 296.91 |
| Martin, Lucas, L,22114 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
Generated 2025-11-04 04:36:06.733 UTC