[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 375 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 102.27 | 96.46 |
| Walker, Brandon, J,15916 | 4793.27 | 0.00 | 0.00 | 0.00 | 4793.27 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Bryant, Gabriel,27656 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hughes, Jasmine,27628 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Walker, Jasmine,13460 | 4693.04 | 0.00 | 0.00 | 0.00 | 4693.04 |
| Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Griffin, Cassidy,26496 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Wilson, Christian,27085 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Gonzales, Brianna, L,21148 | 3223.58 | 0.00 | 0.00 | 2049.10 | 1174.48 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Kelly, Bryan,21349 | 2989.38 | 0.00 | 0.00 | 2989.38 | 0.00 |
| Stewart, Grace, H,24773 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 123.98 | 213.92 |
| Griffin, Jennifer, B,14244 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Evans, Luke,29176 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 14.98 | 96.81 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Lopez, Isaiah,18968 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Murphy, Caitlin, L,14910 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Johnson, Jeremiah, A,14446 | 146.75 | 0.00 | 0.00 | 14.98 | 131.77 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Russell, Oscar, A,12140 | 118.17 | 0.00 | 0.00 | 0.00 | 118.17 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 21.49 | 304.40 |
| Bell, Alexandria, A,13758 | 284.13 | 0.00 | 0.00 | 42.28 | 241.85 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Wilson, Victoria, R,27536 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Jackson, Edward,29042 | 2420.34 | 0.00 | 0.00 | 2420.34 | 0.00 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rivera, Makayla, A,28783 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Smith, Alexandra,28292 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Flores, Julia, E,17263 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Morgan, Marcus, W,28968 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Suri, Carolyn, S,12972 | 175.71 | 0.00 | 0.00 | 0.00 | 175.71 |
| White, Emily, M,15917 | 4679.06 | 0.00 | 0.00 | 0.00 | 4679.06 |
| Gray, Mackenzie, L,17680 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Garcia, Chloe, M,11037 | 2374.23 | 0.00 | 0.00 | 2374.23 | 0.00 |
| Allen, Jack, M,29137 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Martinez, Dominique,28788 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Allen, Angel, G,15571 | 101.85 | 0.00 | 0.00 | 34.89 | 66.96 |
| Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Diaz, Hailey, W,11693 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 219.26 | 789.98 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Butler, Isabel,16241 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 207.93 | 802.63 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 66.26 | 773.89 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 22.18 | 695.10 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 0.00 | 342.03 |
| Kelly, Haley,15511 | 128.56 | 0.00 | 0.00 | 0.00 | 128.56 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 410.31 | 880.02 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
| Coleman, Spencer,15993 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 39.99 | 47.96 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 232.80 | 1148.57 |
| Lewis, Morgan,17410 | 168.74 | 0.00 | 0.00 | 0.00 | 168.74 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 94.24 | 53.95 |
| Roberts, Rebecca,28000 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 676.93 | 0.00 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Powell, Jonathan,23858 | 4712.74 | 0.00 | 3578.27 | 1134.47 | 0.00 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 112.95 | 195.71 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Robinson, Joseph,28141 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 38.88 | 106.94 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Luo, Jodi,29213 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 58.47 | 240.02 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| James, Bryce,13466 | 133.45 | 0.00 | 0.00 | 0.00 | 133.45 |
| Green, Marcus, C,15974 | 208.41 | 0.00 | 0.00 | 91.95 | 116.46 |
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Peterson, Xavier, R,26456 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Hayes, Logan, J,19026 | 113.24 | 0.00 | 0.00 | 37.27 | 75.97 |
Generated 2025-11-02 03:26:03.522 UTC