[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 252 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Collins, Nathan, F,19704 | 1143.46 | 0.00 | 0.00 | 0.00 | 1143.46 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 0.00 | 115.73 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 0.00 | 174.73 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Garcia, Christian, J,16491 | 3106.33 | 0.00 | 0.00 | 751.34 | 2354.99 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 13.98 | 1111.38 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Roberts, Robert, R,18986 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 193.89 | 1073.22 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lobao, Alexandre,18926 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Smith, Eduardo,20691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Barnes, Kayla,24256 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Hill, Carlos,12919 | 257.88 | 0.00 | 0.00 | 0.00 | 257.88 |
| Lewis, Christopher,18755 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 0.00 | 214.26 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 0.00 | 164.21 |
| Adams, Hailey, M,12154 | 4798.53 | 0.00 | 0.00 | 0.00 | 4798.53 |
| Cooper, Timothy, J,20651 | 3198.57 | 0.00 | 0.00 | 2049.10 | 1149.47 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 0.00 | 1228.83 |
| Rodriguez, Natalie,20773 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Morris, Mackenzie, N,26474 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Rodriguez, Destiny, J,22739 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 0.00 | 289.70 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 0.00 | 645.78 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Phillips, Jack, R,25995 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Ye, Alisha, J,22008 | 4141.23 | 0.00 | 3578.27 | 0.00 | 562.96 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Rubio, Jaime, R,15007 | 209.83 | 0.00 | 0.00 | 0.00 | 209.83 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 0.00 | 105.19 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 0.00 | 2049.10 | 1197.45 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Rubio, Javier, E,19726 | 64.24 | 0.00 | 0.00 | 0.00 | 64.24 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
Generated 2025-12-22 00:47:27.623 UTC