[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1062 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Sanchez, Rachel, C,26730 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Baker, Mason, A,13270 | 2394.95 | 0.00 | 0.00 | 0.00 | 2394.95 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 14.98 | 21.98 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Rogers, Paige, H,17125 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Taylor, Marcus, A,18944 | 146.94 | 0.00 | 0.00 | 0.00 | 146.94 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 756.33 | 2362.27 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Perez, Katherine, J,22079 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Turner, Mary,22015 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kelly, Julia,23798 | 67.93 | 0.00 | 0.00 | 67.93 | 0.00 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Wilson, Andrew, R,18236 | 2414.99 | 0.00 | 0.00 | 0.00 | 2414.99 |
| Bell, Brooke, H,23253 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Robyn, J,12765 | 1750.98 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Long, Morgan, H,21352 | 2625.39 | 0.00 | 0.00 | 2071.42 | 553.97 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Harris, Anthony,21447 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Anderson, Tyler, E,13148 | 1137.43 | 0.00 | 0.00 | 1137.43 | 0.00 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Wright, Kaitlyn, G,13434 | 2354.99 | 0.00 | 0.00 | 0.00 | 2354.99 |
| Turner, Eduardo,15876 | 4789.02 | 0.00 | 0.00 | 0.00 | 4789.02 |
| Smith, Hannah, J,25265 | 54.98 | 0.00 | 0.00 | 54.98 | 0.00 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
| Lee, Samantha, B,27378 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Nath, Alison, J,17116 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| White, Emma, N,16090 | 604.96 | 0.00 | 0.00 | 0.00 | 604.96 |
| Richardson, Lauren, C,14867 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Long, Chloe,16784 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Robinson, Abigail, R,18379 | 2362.27 | 0.00 | 0.00 | 0.00 | 2362.27 |
| White, Judith, R,14885 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hughes, Brittany,14387 | 898.46 | 0.00 | 0.00 | 0.00 | 898.46 |
| Brooks, Mariah,21620 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Kaitlyn, J,26310 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Yuan, Brendan, S,24744 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gonzales, Jasmine, C,18392 | 2342.93 | 0.00 | 0.00 | 0.00 | 2342.93 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Simmons, Jose,24647 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Watson, Shelby, J,14911 | 867.97 | 0.00 | 0.00 | 0.00 | 867.97 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Watson, Erin, B,22772 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Ross, Seth, M,18433 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
Generated 2024-11-10 11:34:34.195 UTC