[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 375 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Stewart, Amanda, M,15310 | 94.44 | 0.00 | 0.00 | 0.00 | 94.44 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
| Ashe, Alexis, S,19414 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Anand, Brendan, L,19847 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 37.29 | 162.91 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Blue, Makayla,19000 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Thomas, Edward, E,19147 | 133.71 | 0.00 | 0.00 | 0.00 | 133.71 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 20.93 | 686.57 |
| Jenkins, Megan, R,12074 | 261.38 | 0.00 | 0.00 | 0.00 | 261.38 |
| Gray, Sebastian, B,13878 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Rubio, Ruben, D,18871 | 86.96 | 0.00 | 0.00 | 56.97 | 29.99 |
| Martinez, Grace, M,17385 | 208.69 | 0.00 | 0.00 | 0.00 | 208.69 |
| Kapoor, Preston,21431 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Bryant, Isabelle,23397 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Henderson, Luke,19200 | 109.24 | 0.00 | 0.00 | 0.00 | 109.24 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 0.00 | 200.94 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jenkins, Austin, D,15748 | 296.91 | 0.00 | 0.00 | 0.00 | 296.91 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 0.00 | 214.26 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Edwards, Amber, B,20517 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Patterson, Jeremy,13027 | 2319.26 | 0.00 | 0.00 | 0.00 | 2319.26 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 0.00 | 272.69 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Ye, Alisha, J,22008 | 4141.23 | 0.00 | 3578.27 | 0.00 | 562.96 |
| Lopez, Isaiah,18968 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Sanchez, Richard, L,27406 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Ross, Antonio,18322 | 148.89 | 0.00 | 0.00 | 0.00 | 148.89 |
| Sanchez, Jeremiah, E,22265 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sanchez, Grace,12080 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Alfredo, P,21480 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Cooper, Brianna,25925 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Chen, Ethan,20547 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Hughes, Justin, M,18122 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 0.00 | 94.95 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Young, Kaitlyn, J,25062 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gonzales, Cameron, L,29005 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Brooks, Isaac, M,23385 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Gonzales, Brittany,21710 | 4187.23 | 3578.27 | 0.00 | 0.00 | 608.96 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Peterson, Steven, L,23449 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Stewart, Olivia, B,18749 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Brooke, R,24759 | 4369.59 | 0.00 | 3578.27 | 0.00 | 791.32 |
| Powell, Vanessa,26630 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Nath, Yolanda, A,24625 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Turner, James, E,16841 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 10.24 | 988.98 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 0.00 | 275.44 |
| James, Morgan, E,23245 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 0.00 | 325.89 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 130.94 | 793.67 |
| Washington, Kayla, E,14655 | 174.96 | 0.00 | 0.00 | 0.00 | 174.96 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 0.00 | 143.91 |
| Foster, Isabelle,26377 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
| Turner, Samuel,27420 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hall, Morgan,21726 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Reed, Mariah,26373 | 1565.91 | 0.00 | 0.00 | 1000.44 | 565.47 |
| Coleman, Luke, A,11723 | 152.55 | 0.00 | 0.00 | 39.99 | 112.56 |
| Flores, Julian,15846 | 4943.32 | 0.00 | 0.00 | 0.00 | 4943.32 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Anderson, Isabella,13743 | 2349.98 | 0.00 | 0.00 | 0.00 | 2349.98 |
| Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 0.00 | 258.15 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bryant, Jackson, J,25332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
| Martin, Katherine, J,20273 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Young, Jenna, W,16365 | 2490.18 | 0.00 | 0.00 | 0.00 | 2490.18 |
| Price, Mariah, C,20745 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Brown, Jonathan,11875 | 265.42 | 0.00 | 0.00 | 0.00 | 265.42 |
| Phillips, Adam, R,22748 | 4188.24 | 0.00 | 3578.27 | 0.00 | 609.97 |
Generated 2025-12-22 01:09:02.924 UTC