[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 63 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Thomas, Megan,29071 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Brown, Benjamin, D,15187 | 4725.32 | 0.00 | 0.00 | 0.00 | 4725.32 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Ward, Lucas, N,18363 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Parker, Blake,15008 | 170.53 | 0.00 | 0.00 | 0.00 | 170.53 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 60.47 | 172.24 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 102.27 | 96.46 |
| Rogers, Sara,19874 | 4544.45 | 0.00 | 3374.99 | 0.00 | 1169.46 |
| Price, Isabelle,20182 | 5749.97 | 0.00 | 3374.99 | 0.00 | 2374.98 |
| She, Martha, E,22251 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Thompson, Kayla, D,12363 | 273.90 | 0.00 | 0.00 | 0.00 | 273.90 |
| Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 56.97 | 119.98 |
| Collins, Jonathan,16849 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Smith, Nathan,21764 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Henderson, Luke,19200 | 109.24 | 0.00 | 0.00 | 0.00 | 109.24 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Watson, Cole, A,21768 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Jennifer, J,22120 | 5962.34 | 0.00 | 3578.27 | 2384.07 | 0.00 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Washington, Emma,19123 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Griffin, Miguel,21464 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 0.00 | 177.60 |
| Richardson, Devin, G,21318 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Washington, Hailey, S,25885 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Brooks, Steven, C,14877 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Martinez, Wyatt, R,22881 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Harris, Isabella,17119 | 214.90 | 0.00 | 0.00 | 77.96 | 136.94 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Hayes, Austin,20208 | 3219.58 | 0.00 | 2049.10 | 0.00 | 1170.48 |
| Thomas, David,16836 | 3193.79 | 0.00 | 0.00 | 0.00 | 3193.79 |
| Foster, Nicole, A,23494 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
| Garcia, Cameron,18641 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Hughes, Julia,25061 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Nath, Kenneth, W,17037 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 71.58 | 124.69 |
| Hernandez, Sierra,27393 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 231.72 | 529.21 |
| Ward, Mariah, J,21580 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 2325.96 | 2393.06 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Roberts, Thomas, J,21939 | 4163.24 | 3578.27 | 0.00 | 0.00 | 584.97 |
| Hall, Jason, A,29351 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Ross, Kaitlyn,16121 | 614.47 | 0.00 | 0.00 | 0.00 | 614.47 |
| Stewart, Olivia, B,18749 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Thompson, Madison, L,18788 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Washington, Alexis,19781 | 46.26 | 0.00 | 0.00 | 7.28 | 38.98 |
| Hughes, Nathan, B,12113 | 4737.53 | 0.00 | 0.00 | 2294.99 | 2442.54 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 37.29 | 49.96 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 36.27 | 236.91 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Collins, Sierra,18549 | 1169.46 | 0.00 | 0.00 | 1169.46 | 0.00 |
| Shan, Gabriel, T,27731 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Cooper, Angela,19526 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Foster, Caleb,27112 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Evans, Alexandra,24322 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Ward, Cole,21490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 116.44 | 32.60 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Phillips, Aaron, R,24947 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 127.28 | 0.00 |
| Mitchell, Caleb, K,26806 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Evans, Gabriel,23487 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Barnes, Emily, G,15996 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Alexander, Angelica,22714 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 699.97 | 0.00 |
| Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
Generated 2025-11-06 15:01:15.109 UTC