[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 62 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sanders, Alexa, E,21741 | 4127.25 | 3578.27 | 0.00 | 0.00 | 548.98 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Powell, Spencer,14904 | 468.12 | 0.00 | 0.00 | 0.00 | 468.12 |
| Perez, Charles,26693 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
| Adams, Mason, T,20528 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Lewis, Brianna, H,14282 | 166.24 | 0.00 | 0.00 | 0.00 | 166.24 |
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 0.00 | 88.85 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Flores, Brittany,16906 | 2359.98 | 0.00 | 0.00 | 0.00 | 2359.98 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 0.00 | 696.61 |
| Gonzalez, Jackson, S,14480 | 194.94 | 0.00 | 0.00 | 0.00 | 194.94 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Cooper, Andrea,29323 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 0.00 | 603.53 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Perry, Natalie,17126 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 0.00 | 603.49 |
| Evans, Jesse,21916 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Mitchell, Xavier, L,26533 | 1629.41 | 0.00 | 0.00 | 1000.44 | 628.97 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Long, Jordan,19988 | 4555.47 | 0.00 | 3399.99 | 0.00 | 1155.48 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Hayes, Hannah, J,21656 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 0.00 | 225.92 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Perry, Olivia,20375 | 4438.38 | 0.00 | 0.00 | 2071.42 | 2366.96 |
| Torres, Erin,12182 | 87.25 | 0.00 | 0.00 | 0.00 | 87.25 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 13.98 | 1276.35 |
| Wilson, Chloe, A,11640 | 409.12 | 0.00 | 0.00 | 0.00 | 409.12 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Reed, Erin, I,14353 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Ross, Isabelle, D,18554 | 155.45 | 0.00 | 0.00 | 0.00 | 155.45 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 0.00 | 4811.50 |
| Evans, Dalton, E,12710 | 4774.04 | 0.00 | 0.00 | 0.00 | 4774.04 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Anderson, Tyler, E,13148 | 1137.43 | 0.00 | 0.00 | 0.00 | 1137.43 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 64.47 | 659.09 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Harris, Noah,29256 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 0.00 | 239.60 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Martin, Joshua, A,27607 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 0.00 | 1381.37 |
| Gomez, Krista,12760 | 273.18 | 0.00 | 0.00 | 0.00 | 273.18 |
| Diaz, Luke,12054 | 402.53 | 0.00 | 0.00 | 124.99 | 277.54 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 0.00 | 150.41 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 0.00 | 149.84 |
Generated 2025-12-21 15:13:56.505 UTC