[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 75 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Walker, Hunter,27100 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Bailey, Hailey, R,26270 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Xavier, M,20300 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Lopez, Eduardo, J,26640 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Turner, Timothy, C,14641 | 119.86 | 0.00 | 0.00 | 0.00 | 119.86 |
| Morris, Abigail, C,28776 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Cook, Jacqueline, A,19223 | 60.37 | 0.00 | 0.00 | 0.00 | 60.37 |
| Price, Devin, M,18758 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Wright, Jennifer,26505 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Brooks, Lucas, S,16089 | 342.03 | 0.00 | 0.00 | 0.00 | 342.03 |
| Martin, Noah, A,17657 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 0.00 | 218.91 |
| Butler, Isabel,16241 | 126.96 | 0.00 | 0.00 | 0.00 | 126.96 |
| Rogers, Jade, I,14332 | 102.25 | 0.00 | 0.00 | 0.00 | 102.25 |
| Reed, Paige,22112 | 6047.32 | 0.00 | 3578.27 | 0.00 | 2469.05 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Jones, Nicole,14504 | 112.27 | 0.00 | 0.00 | 0.00 | 112.27 |
| Bryant, Rachel,22019 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Peterson, Alex, M,13423 | 132.90 | 0.00 | 0.00 | 0.00 | 132.90 |
| Morgan, Evan, G,14725 | 318.83 | 0.00 | 0.00 | 0.00 | 318.83 |
| Hall, Taylor, J,16995 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ortega, Javier, P,12785 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Coleman, Samuel, N,17450 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Collins, Charles, B,29041 | 628.45 | 0.00 | 0.00 | 0.00 | 628.45 |
| Bryant, Gabriel,27656 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Watson, Michelle, H,26235 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Russell, Samuel, V,11652 | 310.93 | 0.00 | 0.00 | 0.00 | 310.93 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Diaz, Jason,17374 | 206.63 | 0.00 | 0.00 | 89.46 | 117.17 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Kumar, Elijah,15197 | 156.92 | 0.00 | 0.00 | 0.00 | 156.92 |
| Coleman, Stephanie,22264 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
| Alvarez, Melody,25070 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Simmons, David, E,12017 | 2339.97 | 0.00 | 0.00 | 0.00 | 2339.97 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| Washington, Hannah, A,29130 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Phillips, Jackson, D,23378 | 5317.23 | 0.00 | 3578.27 | 0.00 | 1738.96 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Deng, Damien, A,16873 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Umeda, Masaki,16717 | 233.81 | 0.00 | 0.00 | 0.00 | 233.81 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Foster, Caleb,27112 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Edwards, Logan,25002 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2025-12-20 23:15:53.108 UTC