[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brooks, Steven, C,14877 | 889.47 | 0.00 | 0.00 | 0.00 | 889.47 |
| Davis, Jonathan,29259 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gray, Jared, A,26449 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Alexander, Logan, E,19116 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Gonzales, Nathan, M,12107 | 222.23 | 0.00 | 0.00 | 32.27 | 189.96 |
| Sharma, Thomas, A,18637 | 121.94 | 0.00 | 0.00 | 0.00 | 121.94 |
| Ross, David, M,17143 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Brooks, Victoria, H,16479 | 158.51 | 0.00 | 0.00 | 0.00 | 158.51 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Taylor, Zachary, M,27082 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Clark, Emily, R,12086 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Griffin, Julian, M,11328 | 4718.04 | 0.00 | 0.00 | 2319.99 | 2398.05 |
| Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Roberts, Mason, D,11176 | 1106.68 | 0.00 | 0.00 | 494.64 | 612.04 |
| Simmons, Adam,25327 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Mitchell, Katelyn, A,24496 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Li, Brandon,29339 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Henderson, Jeremiah, D,18961 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 37.27 | 202.33 |
| Lewis, Rachel, J,14900 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 118.46 | 605.10 |
| Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
| Long, Elizabeth, F,12782 | 2400.95 | 0.00 | 0.00 | 0.00 | 2400.95 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Collins, Isaac,26077 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Jai, Kevin,19836 | 78.96 | 0.00 | 0.00 | 38.98 | 39.98 |
| Zukowski, Jake,22058 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Sanchez, Shelby,16021 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Price, Rachel, D,25328 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lazecky, Petr,25864 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
| Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Smith, Lucas, P,18090 | 64.91 | 0.00 | 0.00 | 0.00 | 64.91 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Rogers, Jared, J,12166 | 162.22 | 0.00 | 0.00 | 0.00 | 162.22 |
| Hill, Kaitlyn, M,24659 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Stewart, Lucas, J,29341 | 98.97 | 0.00 | 0.00 | 0.00 | 98.97 |
| Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 137.45 | 565.54 |
| Bailey, Olivia,23892 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 267.62 | 888.28 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Hill, Jordan, J,16005 | 198.73 | 0.00 | 0.00 | 102.27 | 96.46 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 0.00 | 4703.03 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Zhang, Connor, R,13853 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 1228.83 | 0.00 |
| Price, Isabelle,20182 | 5749.97 | 0.00 | 3374.99 | 0.00 | 2374.98 |
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Deng, Wayne,21453 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Bell, Gabrielle,22373 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Foster, Samuel, M,18523 | 160.94 | 0.00 | 0.00 | 128.97 | 31.97 |
| Lewis, Jeremiah,14371 | 87.26 | 0.00 | 0.00 | 49.97 | 37.29 |
| Gray, Mackenzie, L,17680 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 58.47 | 240.02 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 603.49 | 0.00 |
| Morris, Richard,20070 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Madison, C,20492 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
| Ward, Natalie, J,13241 | 2325.96 | 0.00 | 0.00 | 0.00 | 2325.96 |
| Torres, Victoria,17551 | 160.92 | 0.00 | 0.00 | 0.00 | 160.92 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Murphy, Brianna, K,28342 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 213.86 | 911.50 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
| Hall, Luke, E,14745 | 902.46 | 0.00 | 0.00 | 0.00 | 902.46 |
| Brown, Samantha, G,25147 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Smith, Justin, P,19827 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gray, Sebastian, B,13878 | 2366.96 | 0.00 | 0.00 | 0.00 | 2366.96 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Richardson, Erin, R,16331 | 88.85 | 0.00 | 0.00 | 38.88 | 49.97 |
| Hughes, Morgan, T,11642 | 392.89 | 0.00 | 0.00 | 49.48 | 343.41 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2616.86 | 0.00 |
| Davis, Nicholas,13201 | 73.16 | 0.00 | 0.00 | 0.00 | 73.16 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 86.48 | 912.74 |
| Luo, Franklin, J,22027 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
| Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Reed, Paige,22112 | 6047.32 | 3578.27 | 0.00 | 2469.05 | 0.00 |
| Torres, Haley, W,23283 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Jones, Alexandra, B,20202 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Hill, Sydney,26482 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Roberts, Thomas, J,21939 | 4163.24 | 3578.27 | 0.00 | 0.00 | 584.97 |
| Baker, Ian, V,26200 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
| Perry, Benjamin,29165 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 71.97 | 128.97 |
| Navarro, Jerome, B,11519 | 717.28 | 0.00 | 0.00 | 22.18 | 695.10 |
| Reed, Judith, D,25347 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Bradley, Nathaniel,16955 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Diaz, Richard, A,26682 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Evans, Elijah, S,25884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Emily,27267 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Edwards, Elijah, D,28157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Long, Rachel,28283 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-11-03 09:03:37.638 UTC