[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 45 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jai, Logan, H,12031 | 769.49 | 0.00 | 0.00 | 0.00 | 769.49 |
| Taylor, Tyler, A,12032 | 614.96 | 0.00 | 0.00 | 0.00 | 614.96 |
| Hill, Eric, G,25256 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Alexander, Lauren,18950 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Rogers, Faith,24682 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Barnes, Jeremy,21446 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 0.00 | 557.54 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Wilson, Madison, H,19828 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 0.00 | 108.54 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 0.00 | 342.03 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 0.00 | 125.43 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 0.00 | 215.29 |
| Alexander, Sarah,19411 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Long, Xavier,11251 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Ward, Cole,21490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Hannah, M,24666 | 4370.61 | 0.00 | 3578.27 | 0.00 | 792.34 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Flores, Arianna,21727 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Collins, Amanda,20783 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Edwards, Eric,24627 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Anderson, Daniel,20694 | 146.97 | 0.00 | 0.00 | 0.00 | 146.97 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 0.00 | 150.13 |
| Gonzalez, James, M,18842 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Morris, Paige, W,22041 | 4167.23 | 0.00 | 3578.27 | 0.00 | 588.96 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 0.00 | 723.56 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Edwards, Angel, J,29124 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Brown, Dalton, N,21813 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 0.00 | 548.98 |
| Turner, Adam, K,16109 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 0.00 | 298.49 |
| Price, Miranda,26629 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Richardson, Charles, I,12114 | 4719.02 | 0.00 | 0.00 | 0.00 | 4719.02 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Bailey, Richard, N,22050 | 4160.53 | 0.00 | 3578.27 | 0.00 | 582.26 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Thomas, Charles,25094 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 0.00 | 155.45 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perry, Ryan,13249 | 4795.34 | 0.00 | 0.00 | 0.00 | 4795.34 |
| Bennett, Jennifer, G,13708 | 123.94 | 0.00 | 0.00 | 0.00 | 123.94 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Wood, Alexandria, M,24824 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
Generated 2026-01-04 05:47:50.493 UTC