[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1372 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hall, Kaylee, E,19751 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Foster, Kayla,19693 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
| Williams, Zachary, B,27099 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cooper, Christina, C,26512 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Robinson, Jennifer, L,26504 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| James, Timothy,21331 | 2670.89 | 0.00 | 0.00 | 2670.89 | 0.00 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Coleman, Jennifer, L,27298 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Davis, Thomas,16764 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 0.00 | 128.55 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 0.00 | 247.41 |
| Coleman, Spencer,15993 | 597.26 | 0.00 | 0.00 | 0.00 | 597.26 |
| Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bryant, Samantha,18345 | 115.47 | 0.00 | 0.00 | 0.00 | 115.47 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 0.00 | 179.19 |
| Thompson, Brianna, X,18642 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Carter, Elijah,21618 | 2611.07 | 0.00 | 0.00 | 2611.07 | 0.00 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Scott, Allison,14497 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Miller, Victoria,15816 | 188.02 | 0.00 | 0.00 | 0.00 | 188.02 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Russell, Chloe, M,12763 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Green, Chloe, J,14658 | 92.82 | 0.00 | 0.00 | 0.00 | 92.82 |
| Perry, Justin, E,16758 | 3062.34 | 0.00 | 0.00 | 0.00 | 3062.34 |
| Thames, Bernard,23803 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Thomas, Ian,19118 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
| Roberts, Carlos,23196 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Blake,18390 | 141.96 | 0.00 | 0.00 | 0.00 | 141.96 |
| Washington, Ryan,28332 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Morgan, Angela,24665 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hall, Natalie, A,23070 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Barnes, Haley, J,21339 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 127.28 | 0.00 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Ward, Mariah, J,21580 | 44.91 | 0.00 | 0.00 | 0.00 | 44.91 |
| Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Moore, Logan,26348 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Martin, Samuel,15874 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Coleman, Destiny, W,12122 | 4814.04 | 0.00 | 0.00 | 0.00 | 4814.04 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 0.00 | 198.73 |
| Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Lobao, Alexandre,18926 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 0.00 | 143.91 |
| Walker, Destiny, M,16996 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
Generated 2025-12-23 07:10:25.825 UTC