[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 155.73 | 59.56 |
| Tang, Carl,21238 | 32.27 | 0.00 | 0.00 | 32.27 | 0.00 |
| Jenkins, Alexandra, D,11632 | 924.61 | 0.00 | 0.00 | 295.46 | 629.15 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 610.74 | 656.37 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Sanchez, Martin, E,21631 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Mitchell, Jonathan, L,22109 | 5971.33 | 3578.27 | 0.00 | 2393.06 | 0.00 |
| Murphy, Emma,19844 | 5807.93 | 3374.99 | 0.00 | 0.00 | 2432.94 |
| Smith, John,19855 | 5709.96 | 0.00 | 3399.99 | 0.00 | 2309.97 |
| Sandberg, Isaac,13350 | 53.97 | 0.00 | 0.00 | 39.99 | 13.98 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Miller, Benjamin, G,26643 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Turner, Sean,22732 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Johnson, James,23498 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 56.97 | 119.46 |
| Brooks, Makayla,22252 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Perry, Oscar,22785 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Collins, Luis, J,22765 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Taylor, Ryan,17025 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Howard, Morgan, T,22971 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Miller, Chloe, V,22893 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Henderson, Jordan, C,22996 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Foster, Eric,22976 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Harris, Emily, P,19862 | 98.48 | 0.00 | 0.00 | 4.99 | 93.49 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Diaz, Elijah,20000 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Powell, Jonathan,23858 | 4712.74 | 0.00 | 3578.27 | 1134.47 | 0.00 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 2404.46 | 2407.04 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 496.36 | 659.16 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 187.43 | 447.41 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Hughes, Edward,20023 | 4530.47 | 0.00 | 3374.99 | 0.00 | 1155.48 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Bennett, Seth,24493 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Washington, Kayla, E,14655 | 174.96 | 0.00 | 0.00 | 139.96 | 35.00 |
| Yang, Thomas, A,14108 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
| Martinez, Hannah, M,24666 | 4370.61 | 0.00 | 3578.27 | 0.00 | 792.34 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 351.22 | 258.97 |
| Cooper, Ariana,17348 | 205.42 | 0.00 | 0.00 | 0.00 | 205.42 |
| Diaz, Luke,12054 | 402.53 | 0.00 | 0.00 | 139.97 | 262.56 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 95.55 | 146.95 |
| Turner, Jose,11784 | 272.69 | 0.00 | 0.00 | 74.98 | 197.71 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 2443.35 | 574.98 | 0.00 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 1147.77 | 0.00 |
| Watson, Olivia, S,13860 | 93.85 | 0.00 | 0.00 | 54.97 | 38.88 |
| Ross, Xavier, A,12202 | 171.47 | 0.00 | 0.00 | 92.25 | 79.22 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 68.97 | 220.73 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 204.46 | 21.49 |
| Torres, Mariah,16380 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Wright, Kyle,23716 | 26.97 | 0.00 | 0.00 | 26.97 | 0.00 |
| King, Aaron, L,11739 | 4758.03 | 0.00 | 0.00 | 4758.03 | 0.00 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 2354.98 | 2419.06 |
| Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 42.28 | 189.95 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 37.29 | 49.96 |
| Price, Nicole, N,15815 | 141.83 | 0.00 | 0.00 | 56.97 | 84.86 |
| Hayes, Oscar,26527 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Fernandez, Cesar,20035 | 5694.98 | 0.00 | 3374.99 | 0.00 | 2319.99 |
| Washington, Ian, M,24664 | 4368.58 | 0.00 | 3578.27 | 0.00 | 790.31 |
| Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
| Hayes, Austin,20208 | 3219.58 | 0.00 | 2049.10 | 0.00 | 1170.48 |
| Long, Natalie,14363 | 192.34 | 0.00 | 0.00 | 14.98 | 177.36 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Ward, Ian,12056 | 213.92 | 0.00 | 0.00 | 0.00 | 213.92 |
| Green, Sophia, E,24977 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Watson, Kimberly, A,20188 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Phillips, Miguel,20498 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Gray, Brianna,24960 | 3008.82 | 0.00 | 2443.35 | 565.47 | 0.00 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Lazecky, Petr,25864 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 1000.44 | 0.00 | 0.00 |
| Brown, Samantha, G,25147 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Christian, R,26686 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Thomas,21629 | 2624.08 | 0.00 | 0.00 | 2049.10 | 574.98 |
| Nelson, Adam, B,27402 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Perry, Olivia,20375 | 4438.38 | 0.00 | 2071.42 | 0.00 | 2366.96 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 2071.42 | 0.00 | 2337.27 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Carter, Sydney,12959 | 203.92 | 0.00 | 0.00 | 0.00 | 203.92 |
| Carter, Madeline, A,27522 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Barnes, Brittany, R,15340 | 156.04 | 0.00 | 0.00 | 74.46 | 81.58 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 80.96 | 131.05 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 119.89 | 94.46 |
| Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| White, Edward, J,15847 | 205.46 | 0.00 | 0.00 | 0.00 | 205.46 |
| Garcia, Isabella,18382 | 204.94 | 0.00 | 0.00 | 0.00 | 204.94 |
| Foster, Edward, R,18355 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
| Foster, Isabel, M,21745 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Anderson, Destiny,12895 | 336.65 | 0.00 | 0.00 | 37.27 | 299.38 |
| Johnson, Jeremiah, A,14446 | 146.75 | 0.00 | 0.00 | 14.98 | 131.77 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 4.99 | 143.95 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Russell, Oscar, A,12140 | 118.17 | 0.00 | 0.00 | 0.00 | 118.17 |
| Fernandez, Ruth,20546 | 3246.55 | 0.00 | 2049.10 | 0.00 | 1197.45 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 2049.10 | 0.00 | 2350.96 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Phillips, Jack, R,25995 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
Generated 2024-09-20 04:17:27.341 UTC