[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 0 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Ross, Alexia, S,13231 | 247.90 | 0.00 | 0.00 | 0.00 | 247.90 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Hill, Timothy,14871 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Yang, Justin, S,15363 | 4719.04 | 0.00 | 0.00 | 0.00 | 4719.04 |
| Henderson, Abigail,20441 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Isla, Julian, A,13732 | 108.96 | 0.00 | 0.00 | 4.99 | 103.97 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 0.00 | 192.34 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 198.94 | 912.42 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 0.00 | 240.01 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 118.46 | 605.10 |
| Jones, Charles,22882 | 101.45 | 0.00 | 0.00 | 0.00 | 101.45 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Carter, Jesse, E,22141 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Flores, Zachary, H,23376 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Lal, Robert, L,14084 | 138.68 | 0.00 | 0.00 | 0.00 | 138.68 |
| Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 105.05 | 741.72 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 121.93 | 553.71 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 137.45 | 565.54 |
| Lee, John,19801 | 193.01 | 0.00 | 0.00 | 0.00 | 193.01 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 58.97 | 78.98 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 0.00 | 176.43 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 2329.98 | 2400.34 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 118.96 | 533.02 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 158.36 | 634.91 |
| Lal, Luke, L,11019 | 698.23 | 0.00 | 0.00 | 139.93 | 558.30 |
| Hall, Elizabeth, L,13474 | 339.48 | 0.00 | 0.00 | 0.00 | 339.48 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 267.62 | 888.28 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 0.00 | 74.14 |
| Perez, Kaitlyn, A,12081 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Ward, Angela, M,27756 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Wilson, Daniel, K,14281 | 4746.30 | 0.00 | 0.00 | 0.00 | 4746.30 |
| Wilson, Tyler, L,15879 | 196.93 | 0.00 | 0.00 | 0.00 | 196.93 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 29.99 | 30.97 |
| Stewart, Jessica,16097 | 103.55 | 0.00 | 0.00 | 46.58 | 56.97 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Wilson, Fernando,16643 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 237.82 | 1067.84 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 94.46 | 30.97 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 0.00 | 105.19 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 432.39 | 723.13 |
| Hayes, Luis,12880 | 200.73 | 0.00 | 0.00 | 0.00 | 200.73 |
Generated 2025-11-01 15:32:44.444 UTC