[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 36.59 | 117.95 |
| Parker, Eduardo, M,12939 | 169.42 | 0.00 | 0.00 | 110.20 | 59.22 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 244.70 | 390.14 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2589.09 | 0.00 |
| Cooper, Brooke,19536 | 1120.49 | 0.00 | 0.00 | 1120.49 | 0.00 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 572.88 | 436.36 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 144.97 | 127.72 |
| Cooper, Amanda, P,14606 | 4716.02 | 0.00 | 0.00 | 2331.95 | 2384.07 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 68.97 | 155.94 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 2367.92 | 0.00 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 44.88 | 56.97 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 101.26 | 185.04 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 32.60 | 164.44 |
| Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 205.68 | 634.47 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Martin, Christian, V,19709 | 197.25 | 0.00 | 0.00 | 69.97 | 127.28 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 4823.01 | 0.00 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 270.15 | 63.97 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 228.43 | 0.00 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 88.85 | 0.00 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 97.81 | 29.99 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Bennett, Jordyn, L,22230 | 4223.23 | 3578.27 | 0.00 | 0.00 | 644.96 |
| Martin, Jill, C,11824 | 181.03 | 0.00 | 0.00 | 69.97 | 111.06 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 451.41 | 265.87 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Ross, Kelly,26076 | 76.96 | 0.00 | 0.00 | 76.96 | 0.00 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 146.30 | 14.98 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 108.54 | 0.00 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 13.98 | 257.47 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 57.09 | 135.92 |
| White, Emily, M,15917 | 4679.06 | 0.00 | 0.00 | 0.00 | 4679.06 |
| Stewart, Cody, A,21284 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 415.52 | 291.98 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 56.97 | 84.86 |
| Chen, David,27208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Miller, Joseph, A,22713 | 4148.19 | 3578.27 | 0.00 | 0.00 | 569.92 |
| Russell, Katherine,28771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 156.45 | 169.44 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 146.04 | 50.23 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 372.94 | 323.67 |
| Mitchell, Bailey, B,26706 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Brooks, Bryce,12061 | 140.17 | 0.00 | 0.00 | 125.19 | 14.98 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Mitchell, Kaylee, R,14566 | 401.49 | 0.00 | 0.00 | 195.59 | 205.90 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 2359.98 | 2433.04 |
| Stewart, Garrett, O,15762 | 564.48 | 0.00 | 0.00 | 564.48 | 0.00 |
| Hill, Alexandra, K,15172 | 215.45 | 0.00 | 0.00 | 145.48 | 69.97 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 109.95 | 163.95 |
| Diaz, Faith, M,22363 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 239.94 | 56.97 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 38.88 | 106.94 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 155.73 | 59.56 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 199.43 | 209.69 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 155.45 | 0.00 |
| Stewart, Alexandria,17476 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 848.47 | 0.00 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 4719.02 | 0.00 |
| Martinez, Matthew, L,16009 | 170.45 | 0.00 | 0.00 | 0.00 | 170.45 |
| Malhotra, Brenda,13391 | 2405.47 | 0.00 | 0.00 | 0.00 | 2405.47 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 155.23 | 153.43 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 756.33 | 2362.27 |
| Cook, Jacqueline, A,19223 | 60.37 | 0.00 | 0.00 | 60.37 | 0.00 |
| Morgan, Evan, G,14725 | 318.83 | 0.00 | 0.00 | 228.85 | 89.98 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 128.55 | 0.00 |
| Jones, Natalie, A,11845 | 197.20 | 0.00 | 0.00 | 82.26 | 114.94 |
| Anderson, Tyler, E,13148 | 1137.43 | 0.00 | 0.00 | 1137.43 | 0.00 |
| Ramirez, Melanie, V,16363 | 2481.82 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Li, Jordan,17026 | 261.39 | 0.00 | 0.00 | 261.39 | 0.00 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 2339.97 | 0.00 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 115.73 | 0.00 |
| Russell, Xavier,12964 | 119.95 | 0.00 | 0.00 | 29.99 | 89.96 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 83.95 | 255.53 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Flores, Cassidy, L,23368 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 43.97 | 113.94 |
| Miller, Destiny,25157 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Lewis, Zachary, L,14760 | 167.26 | 0.00 | 0.00 | 47.28 | 119.98 |
| Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 63.99 | 29.99 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2648.07 | 0.00 |
| Jenkins, Dakota, D,20679 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 351.22 | 258.97 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 131.23 | 68.97 |
| Henderson, Stephanie, L,19224 | 352.52 | 0.00 | 0.00 | 168.04 | 184.48 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 56.97 | 89.97 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 71.97 | 79.95 |
| Miller, Jill,12914 | 2329.98 | 0.00 | 0.00 | 2329.98 | 0.00 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Sanchez, Richard, L,27406 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Taylor, Brianna,17027 | 230.90 | 0.00 | 0.00 | 230.90 | 0.00 |
| Gray, Jared, A,26449 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Torres, Christina, M,20746 | 119.95 | 0.00 | 0.00 | 119.95 | 0.00 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Clark, Destiny, L,28600 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Hall, Jason, A,29351 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Coleman, Ian,21276 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Austin,27643 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Jackson, Andrew,20479 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 73.54 | 107.25 |
| Ross, Seth, M,18433 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Ward, Nicole, L,21272 | 4435.38 | 0.00 | 0.00 | 2071.42 | 2363.96 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 67.27 | 107.46 |
| Serrano, Albert, E,13328 | 4708.02 | 0.00 | 0.00 | 4708.02 | 0.00 |
| Butler, Ana,26040 | 3018.33 | 0.00 | 0.00 | 3018.33 | 0.00 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 91.95 | 29.99 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 79.97 | 14.98 |
| Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 21.98 | 0.00 |
Generated 2026-07-21 21:08:27.692 UTC