[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 62 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Robinson, Sarah, A,27028 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 0.00 | 218.91 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Foster, Trevor, J,28964 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 0.00 | 325.89 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 0.00 | 87.95 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 0.00 | 222.23 |
| Sanders, Megan, A,15376 | 136.24 | 0.00 | 0.00 | 0.00 | 136.24 |
| Coleman, Joan, W,26699 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 0.00 | 1381.37 |
| Ward, Jade, D,14661 | 195.02 | 0.00 | 0.00 | 0.00 | 195.02 |
| Hayes, Brittany,13941 | 286.82 | 0.00 | 0.00 | 0.00 | 286.82 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Cooper, Stephanie,24976 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 0.00 | 603.49 |
| Murphy, Olivia, V,20206 | 3204.58 | 0.00 | 2049.10 | 0.00 | 1155.48 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Gray, Alexandria, E,25363 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Hughes, Stephanie,26316 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Perry, Olivia,20375 | 4438.38 | 0.00 | 0.00 | 2071.42 | 2366.96 |
| Hayes, Carson, A,12447 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Lewis, Ryan, A,20312 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Thomas, O,16020 | 595.96 | 0.00 | 0.00 | 0.00 | 595.96 |
| Bradley, Melanie, G,13343 | 4720.27 | 0.00 | 0.00 | 0.00 | 4720.27 |
| Campbell, Alex,11984 | 4730.32 | 0.00 | 0.00 | 0.00 | 4730.32 |
| Patterson, Nicole,19729 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Hernandez, Jonathan, J,19014 | 65.95 | 0.00 | 0.00 | 0.00 | 65.95 |
| Campbell, Kevin, S,12177 | 4811.50 | 0.00 | 0.00 | 0.00 | 4811.50 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 0.00 | 1010.56 |
| Lee, William,13185 | 149.84 | 0.00 | 0.00 | 0.00 | 149.84 |
| Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 0.00 | 282.04 |
| Rogers, Sean, G,18685 | 124.46 | 0.00 | 0.00 | 0.00 | 124.46 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Diaz, Luke,12054 | 402.53 | 0.00 | 0.00 | 124.99 | 277.54 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Hall, Jan, M,11740 | 334.12 | 0.00 | 0.00 | 0.00 | 334.12 |
| Brooks, Ian, W,28290 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Adams, Hailey, M,12154 | 4798.53 | 0.00 | 0.00 | 0.00 | 4798.53 |
| Morris, Mackenzie, N,26474 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 0.00 | 289.70 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Powell, Blake, J,22371 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 0.00 | 82.18 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, John, A,14436 | 4776.01 | 0.00 | 0.00 | 0.00 | 4776.01 |
| Rubio, Kellie,27653 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
| Coleman, Vanessa,21589 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Zhang, Robert,18855 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Nelson, Sean,11841 | 307.97 | 0.00 | 0.00 | 0.00 | 307.97 |
| Hill, Eric, G,25256 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 71.58 | 1035.10 |
| Cannata, Gabrielle, C,21725 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Diaz, Kaitlyn, B,29230 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Davis, Thomas,16764 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 0.00 | 179.19 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Adams, Kyle, E,18812 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hayes, Jeremiah, W,20086 | 128.55 | 0.00 | 0.00 | 0.00 | 128.55 |
| Murphy, Caitlin, L,14910 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Harris, Samuel, M,24771 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wright, Carol, C,12928 | 247.41 | 0.00 | 0.00 | 0.00 | 247.41 |
| Murphy, Richard, M,22299 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Gonzalez, Katherine,22234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Collins, Jonathan,16849 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 64.47 | 659.09 |
| Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
| Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 0.00 | 164.46 |
| Stewart, Alex, M,20084 | 63.15 | 0.00 | 0.00 | 0.00 | 63.15 |
| Gonzales, Ashley, C,18600 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Dominguez, Meghan,14370 | 122.56 | 0.00 | 0.00 | 0.00 | 122.56 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 0.00 | 151.84 |
| Torres, Xavier,16840 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 34.99 | 1270.67 |
| Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
| Moreno, Renee, C,12936 | 265.22 | 0.00 | 0.00 | 0.00 | 265.22 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Brown, Morgan,29197 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
| Powell, Miranda, J,15304 | 4843.00 | 0.00 | 0.00 | 0.00 | 4843.00 |
| Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 0.00 | 846.77 |
| Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 0.00 | 2071.42 | 2337.27 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Stewart, Sara,17347 | 119.72 | 0.00 | 0.00 | 0.00 | 119.72 |
| Patterson, Taylor,12147 | 271.45 | 0.00 | 0.00 | 0.00 | 271.45 |
| Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Sanchez, Jared, J,25850 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Bryant, Nathan,21450 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rubio, Jaime, R,15007 | 209.83 | 0.00 | 0.00 | 0.00 | 209.83 |
| Bell, Chase,18091 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Price, Devin, M,18758 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Thompson, Ryan, M,11330 | 1111.36 | 0.00 | 0.00 | 0.00 | 1111.36 |
| Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
| Ross, Natalie, J,12916 | 261.22 | 0.00 | 0.00 | 0.00 | 261.22 |
| She, Kenneth,16096 | 212.01 | 0.00 | 0.00 | 0.00 | 212.01 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
| Rodriguez, Natalie,20773 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Campbell, Lucas,29329 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Peterson, Morgan, J,16834 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Generated 2025-12-21 22:31:34.157 UTC