[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 314 < SKIP 1000 > < TAKE 1000
193 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Blanco, Randall,26321 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 0.00 | 192.34 |
| Powell, Angela, R,12970 | 471.11 | 0.00 | 0.00 | 0.00 | 471.11 |
| Martin, Brandon, S,21691 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Roberts, Amber, W,21582 | 2638.06 | 0.00 | 0.00 | 2049.10 | 588.96 |
| Campbell, Gabriella,18841 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| 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 |
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Diaz, Hunter, S,27242 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Butler, Ana,26040 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Garcia, Hunter, J,21305 | 3204.58 | 0.00 | 0.00 | 2049.10 | 1155.48 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 0.00 | 339.48 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Alexander, Nathan, A,18795 | 1198.97 | 0.00 | 0.00 | 0.00 | 1198.97 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 0.00 | 213.52 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 0.00 | 125.43 |
| Peterson, Christina,28976 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Harris, Matthew,14330 | 806.76 | 0.00 | 0.00 | 0.00 | 806.76 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 0.00 | 164.21 |
| Sanchez, Richard, L,27406 | 1357.97 | 0.00 | 0.00 | 782.99 | 574.98 |
| Bell, Julia,21652 | 2646.06 | 0.00 | 0.00 | 2646.06 | 0.00 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Allen, Luke,11316 | 2349.98 | 0.00 | 0.00 | 2349.98 | 0.00 |
| Martinez, Dominique,28788 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| King, Morgan,19681 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Russell, Melanie, B,15478 | 182.83 | 0.00 | 0.00 | 38.88 | 143.95 |
| Thomas, Jessica,16848 | 94.48 | 0.00 | 0.00 | 94.48 | 0.00 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Phillips, Andrea,18573 | 83.74 | 0.00 | 0.00 | 0.00 | 83.74 |
| Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
| Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 123.98 | 89.96 |
| Butler, Trevor,27415 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chow, Candice,19232 | 60.96 | 0.00 | 0.00 | 0.00 | 60.96 |
| Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 0.00 | 4803.31 |
| Bradley, Nathaniel,16955 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| White, Abigail, T,15866 | 145.82 | 0.00 | 0.00 | 0.00 | 145.82 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Jai, Kevin,19836 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 0.00 | 122.26 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Sharma, Kathryn,20740 | 140.94 | 0.00 | 0.00 | 0.00 | 140.94 |
| Barnes, Elizabeth, J,24939 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Cook, Joan,23554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 0.00 | 239.60 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Barnes, Kayla,24256 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harris, Seth, M,16140 | 2528.33 | 0.00 | 0.00 | 0.00 | 2528.33 |
| Powell, Sydney, M,14886 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Lewis, Christopher,18755 | 86.96 | 0.00 | 0.00 | 0.00 | 86.96 |
| Anderson, Madison, G,28359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Foster, Aaron,15566 | 4912.47 | 0.00 | 0.00 | 0.00 | 4912.47 |
| Chandra, Allen,29327 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanchez, Katherine, S,24399 | 132.94 | 0.00 | 0.00 | 0.00 | 132.94 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Anderson, Jasmine, A,23553 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Nelson, Kevin,14765 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Reed, Gabriella, A,27437 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Smith, Austin,13707 | 149.05 | 0.00 | 0.00 | 0.00 | 149.05 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Hughes, Samantha,27215 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Stewart, Lucas, J,29341 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Hughes, Justin, M,18122 | 2439.99 | 0.00 | 0.00 | 0.00 | 2439.99 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Jai, Luis, A,18320 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Hall, Kyle, J,17491 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
| Butler, Benjamin, C,18972 | 2369.97 | 0.00 | 0.00 | 0.00 | 2369.97 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Julia,28121 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Jai, Logan, H,12031 | 769.49 | 0.00 | 0.00 | 0.00 | 769.49 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Gonzales, Ryan, M,17373 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Parker, Kaylee, M,27738 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Chen, Jonathan, G,13096 | 200.69 | 0.00 | 0.00 | 0.00 | 200.69 |
| Perry, Brandon,22095 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Mitchell, Thomas, J,13711 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Henderson, Jeremiah, D,18961 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Alexander, Caroline,17654 | 1759.97 | 0.00 | 0.00 | 0.00 | 1759.97 |
| Raman, Emmanuel, W,19554 | 86.95 | 0.00 | 0.00 | 0.00 | 86.95 |
| Garcia, Xavier, M,20300 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Bryant, Dakota, L,17613 | 2401.95 | 0.00 | 0.00 | 0.00 | 2401.95 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| James, Adrian, C,25340 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rivera, Hailey, R,20792 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Brandon, L,25621 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Thompson, Madison, L,18788 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Alexander, Sarah,19411 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Wood, Brittany,28777 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Collins, Isaac,26077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hayes, Jason,26176 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sánchez, Angela, C,17655 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Rivera, Sara,18785 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Perez, Barry, M,27282 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gray, Marcus, T,18389 | 2401.45 | 0.00 | 0.00 | 0.00 | 2401.45 |
| Collins, Allison,28581 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Ma, Tiffany,21577 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Henderson, Austin,27643 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Rogers, Olivia,12020 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Collins, Jonathan,16849 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Li, Rafael, M,21752 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Wright, Kaitlyn, G,13434 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lal, Jack, R,18525 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Patterson, Austin, O,27024 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ward, Destiny,16128 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Walker, Jacob, N,29027 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Foster, Nicole, A,23494 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Butler, Jackson, J,18324 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Alexander, Gavin, K,29322 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Jones, Alexander, I,20021 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Hughes, Austin, P,18368 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Allen, Madeline,29240 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Morris, Haley, A,23548 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Griffin, James,28189 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Washington, Adam, G,25437 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Collins, Eduardo,13987 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Williams, Sydney, J,15334 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Torres, Abigail,25367 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| _SUM | 1806517.50 | 25543.71 | 492798.22 | 255388.12 | 1032787.45 |
Generated 2025-12-24 07:53:24.656 UTC