[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 625 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Wilson, Fernando,16643 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 494.64 | 612.04 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Reed, Paige,22112 | 6047.32 | 3578.27 | 0.00 | 2469.05 | 0.00 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 60.47 | 172.24 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 2294.99 | 2442.54 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 0.00 | 240.01 |
| Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Hughes, Justin, M,18122 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 37.27 | 299.38 |
| Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
| Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Foster, Carson, L,16959 | 135.35 | 0.00 | 0.00 | 85.48 | 49.87 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Alexander, Gavin, K,29322 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Davis, Justin,28074 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Alexander, Julia, J,15291 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stewart, Grace, H,24773 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Hayes, Logan, J,19026 | 113.24 | 0.00 | 0.00 | 37.27 | 75.97 |
| Miller, Andrew, C,27110 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 56.97 | 91.22 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Flores, Stephanie,25992 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| White, James,25331 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lee, Ian,19646 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 0.00 | 232.23 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 149.93 | 0.00 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Griffin, Maria,18407 | 63.25 | 0.00 | 0.00 | 0.00 | 63.25 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 12.94 | 201.41 |
| Williams, Destiny, S,15881 | 564.99 | 0.00 | 0.00 | 564.99 | 0.00 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Nelson, Luis,23488 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Watson, Kimberly, A,20188 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 33.98 | 213.43 |
| Green, Kaylee, C,26185 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Anna, K,12451 | 2367.92 | 0.00 | 0.00 | 0.00 | 2367.92 |
| Cooper, Alexandra,19541 | 131.24 | 0.00 | 0.00 | 0.00 | 131.24 |
| Ramirez, Melanie, V,16363 | 2481.82 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Richardson, Evan, J,15488 | 165.30 | 0.00 | 0.00 | 0.00 | 165.30 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Gonzales, Paige,21702 | 91.94 | 0.00 | 0.00 | 39.98 | 51.96 |
| Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 54.58 | 49.97 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 0.00 | 174.73 |
| Ortega, Byron,23306 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Thomas, Jessica,16848 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Hughes, Morgan, T,11642 | 392.89 | 0.00 | 0.00 | 49.48 | 343.41 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 292.94 | 862.58 |
| Hughes, Miranda,26678 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 0.00 | 73.75 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 42.28 | 136.91 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 14.98 | 107.28 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Gonzalez, Logan, J,17483 | 64.50 | 0.00 | 0.00 | 32.28 | 32.22 |
| Sanchez, Shelby,16021 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Perry, Lauren,24816 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Andersen, Latoya, J,29057 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Sanders, Isaiah,25873 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Hayes, Oscar,26527 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Rogers, Shelby,11712 | 127.80 | 0.00 | 0.00 | 42.59 | 85.21 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 127.96 | 87.33 |
| Russell, Samuel, V,11652 | 310.93 | 0.00 | 0.00 | 0.00 | 310.93 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Gonzalez, Morgan,13065 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Martin, James, M,19870 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 98.97 | 597.64 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 71.97 | 128.97 |
| Jackson, Edward,29042 | 2420.34 | 0.00 | 0.00 | 2420.34 | 0.00 |
| Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 127.28 | 0.00 |
| Griffin, Madison, A,25093 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Smith, Megan, J,26716 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Gray, Mackenzie, L,17680 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 248.38 | 1142.17 |
Generated 2025-11-03 09:02:51.745 UTC