[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 63 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Bell, Eduardo,27101 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ramirez, Makayla, L,17509 | 98.72 | 0.00 | 0.00 | 0.00 | 98.72 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Bailey, Lauren,15864 | 103.55 | 0.00 | 0.00 | 0.00 | 103.55 |
| Evans, James, C,20665 | 4408.56 | 0.00 | 0.00 | 2049.10 | 2359.46 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Phillips, Jack, R,25995 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Jai, Connor, D,27253 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Jones, Zachary, J,27285 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Coleman, Ashley,27297 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 0.00 | 125.43 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Moore, Jonathan,20478 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Thomas, Megan,29071 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bell, Christina,26099 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 0.00 | 82.18 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 0.00 | 123.94 |
| Russell, Elijah, M,11835 | 4772.30 | 0.00 | 0.00 | 2319.26 | 2453.04 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 0.00 | 196.27 |
| Miller, Kayla, A,23673 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Russell, Jessica,26572 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Thomas, Richard,27557 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Winston, Ethan, R,21622 | 2612.06 | 0.00 | 0.00 | 2049.10 | 562.96 |
| Wilson, Victoria, R,27536 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Washington, Alexia,27613 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2049.10 | 598.97 |
| King, Jordan, C,11020 | 2316.97 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Washington, Riley, L,18544 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Davis, Richard, R,15549 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Scott, Sean, F,24755 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzales, Emily, P,21777 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Perry, Samuel,18811 | 100.96 | 0.00 | 0.00 | 0.00 | 100.96 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 0.00 | 177.60 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Edwards, Hailey,24258 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Nelson, Jose,19217 | 185.02 | 0.00 | 0.00 | 0.00 | 185.02 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hayes, Hannah, J,21656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Gray, Cody, C,14459 | 4775.01 | 0.00 | 0.00 | 0.00 | 4775.01 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Ian,26085 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Mohamed, Samantha, A,29277 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Foster, Jessica,26069 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
Generated 2025-12-23 12:13:41.482 UTC