[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 124 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Howard, Natalie,13491 | 54.96 | 0.00 | 0.00 | 14.98 | 39.98 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Perry, Eric,18314 | 115.73 | 0.00 | 0.00 | 0.00 | 115.73 |
| Harris, Emily, P,19862 | 98.48 | 0.00 | 0.00 | 0.00 | 98.48 |
| Thompson, Tyler,27502 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 0.00 | 610.19 |
| Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Thomas, Jessica,16848 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 0.00 | 226.43 |
| Howard, Alyssa, A,11513 | 863.95 | 0.00 | 0.00 | 0.00 | 863.95 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 0.00 | 4811.50 |
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 0.00 | 275.50 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 0.00 | 74.14 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 73.87 | 1316.68 |
| Young, Julia, J,27414 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 0.00 | 94.95 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 0.00 | 634.84 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Price, Lauren, J,14079 | 184.74 | 0.00 | 0.00 | 37.29 | 147.45 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 0.00 | 287.20 |
| Yuan, Carly,19839 | 194.96 | 0.00 | 0.00 | 0.00 | 194.96 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 0.00 | 4843.00 |
| Richardson, Evan, J,15488 | 165.30 | 0.00 | 0.00 | 0.00 | 165.30 |
| Nelson, Adam, B,27402 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hughes, Samantha,27215 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Anderson, Daniel,20694 | 146.97 | 0.00 | 0.00 | 0.00 | 146.97 |
| Sanchez, Mariah, R,19220 | 66.65 | 0.00 | 0.00 | 0.00 | 66.65 |
| Zhang, Heather,16654 | 3056.32 | 0.00 | 0.00 | 0.00 | 3056.32 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanchez, Stephanie,17867 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Stewart, Brooke, R,24759 | 4369.59 | 0.00 | 3578.27 | 0.00 | 791.32 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Morgan, Isaiah,18978 | 118.73 | 0.00 | 0.00 | 0.00 | 118.73 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Harris, Joshua, L,20280 | 95.94 | 0.00 | 0.00 | 0.00 | 95.94 |
| Garcia, Carmen, J,24781 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Flores, Luke, L,24733 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, Charles,25094 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gray, Brianna,24960 | 3008.82 | 0.00 | 2443.35 | 0.00 | 565.47 |
| Hall, Eduardo,16847 | 189.94 | 0.00 | 0.00 | 0.00 | 189.94 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 61.97 | 185.04 |
| Carter, Luis, E,25883 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Wang, Karen, P,19553 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Murphy, Dalton, N,27043 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Phillips, Mackenzie,12444 | 228.43 | 0.00 | 0.00 | 0.00 | 228.43 |
| Howard, Isaiah,25981 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Hayes, Logan, J,19026 | 113.24 | 0.00 | 0.00 | 0.00 | 113.24 |
| Harris, Edward,27062 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Perry, Jennifer, J,22120 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Hayes, Arianna,25991 | 2845.52 | 0.00 | 0.00 | 2181.56 | 663.96 |
| Gonzales, Cameron, L,29005 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Flores, Stephanie,25992 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 0.00 | 4823.01 |
| Stewart, Julia, L,12902 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Adams, Hailey, M,12154 | 4798.53 | 0.00 | 0.00 | 0.00 | 4798.53 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Perez, Jordan, A,29267 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Grace, A,20189 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Hailey, R,26270 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Anderson, Ryan, W,13271 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 0.00 | 233.81 |
| Bailey, Mariah, L,27243 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Foster, Aaron,15566 | 4912.47 | 0.00 | 0.00 | 0.00 | 4912.47 |
| Thomas, Samantha,21690 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 0.00 | 141.83 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 0.00 | 334.12 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 0.00 | 4703.03 |
| Torres, Pedro, E,16958 | 168.02 | 0.00 | 0.00 | 0.00 | 168.02 |
| Rogers, Faith,24682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Deng, Wayne,21453 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 0.00 | 88.85 |
| Adams, Mackenzie, A,14640 | 812.42 | 0.00 | 0.00 | 0.00 | 812.42 |
| Peterson, Mason, A,18570 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Campbell, Angel, D,19546 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Malhotra, Kristi, S,15175 | 4850.33 | 0.00 | 0.00 | 0.00 | 4850.33 |
| Brooks, Paige,22232 | 5985.31 | 0.00 | 3578.27 | 0.00 | 2407.04 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Reed, Catherine, M,20380 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Clark, Lauren,17034 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sara, Ivan, L,25090 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| James, Christina,17409 | 219.92 | 0.00 | 0.00 | 0.00 | 219.92 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 0.00 | 336.65 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Roberts, Noah, S,27042 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
Generated 2025-12-23 07:42:12.695 UTC