[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 13.98 | 136.43 |
| Edwards, Mackenzie, K,23458 | 41.95 | 0.00 | 0.00 | 0.00 | 41.95 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Brown, Nicholas, S,11506 | 675.64 | 0.00 | 0.00 | 121.93 | 553.71 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 0.00 | 478.95 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 0.00 | 225.44 |
| Jackson, Victoria,27019 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 0.00 | 121.56 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 0.00 | 66.25 |
| Martin, Christian, V,19709 | 197.25 | 0.00 | 0.00 | 0.00 | 197.25 |
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 699.97 | 0.00 |
| Patterson, Jocelyn, D,23559 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Reed, Sean, L,14597 | 4803.31 | 0.00 | 0.00 | 0.00 | 4803.31 |
| Price, Marissa,15826 | 160.74 | 0.00 | 0.00 | 120.48 | 40.26 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 0.00 | 109.95 |
| Thomas, Jeremiah,18372 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 99.97 | 14.98 |
| Brown, Dylan, J,12449 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Raje, Mindy, A,16083 | 561.97 | 0.00 | 0.00 | 0.00 | 561.97 |
| Patterson, Aaron, W,19113 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Lewis, Isabella,26242 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Morris, Mackenzie, N,26474 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| _SUM | 1806517.50 | 68775.49 | 488463.69 | 323085.41 | 926192.91 |
| Allen, Mason,17625 | 2431.95 | 0.00 | 0.00 | 0.00 | 2431.95 |
| Flores, Julian,15846 | 4943.32 | 0.00 | 0.00 | 0.00 | 4943.32 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 676.93 | 0.00 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
| Ramirez, Melanie, V,16363 | 2481.82 | 0.00 | 0.00 | 2481.82 | 0.00 |
| Flores, Eduardo, S,28969 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Thomas, Matthew, K,13239 | 185.70 | 0.00 | 0.00 | 0.00 | 185.70 |
| Barnes, Alexandra, P,22268 | 6031.31 | 0.00 | 3578.27 | 0.00 | 2453.04 |
| White, Miguel, S,13988 | 195.52 | 0.00 | 0.00 | 0.00 | 195.52 |
| Garcia, Rachel, L,12986 | 4823.01 | 0.00 | 0.00 | 2369.97 | 2453.04 |
| Thompson, Ethan,19989 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Parker, James,11808 | 610.19 | 0.00 | 0.00 | 186.77 | 423.42 |
| Phillips, Adam, R,22748 | 4188.24 | 0.00 | 3578.27 | 0.00 | 609.97 |
| Bryant, Zachary,21655 | 2648.07 | 0.00 | 0.00 | 2648.07 | 0.00 |
| Moore, Ian, L,24639 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Reed, Marcus,14582 | 111.79 | 0.00 | 0.00 | 14.98 | 96.81 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 118.96 | 533.02 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Posti, Juha-Pekka,22219 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Morgan, Juan, C,18821 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Smith, John,19855 | 5709.96 | 0.00 | 3399.99 | 0.00 | 2309.97 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Edwards, Elijah, D,28157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
| Hughes, Antonio, P,15913 | 712.27 | 0.00 | 0.00 | 712.27 | 0.00 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Garcia, Alexandra, J,14107 | 819.46 | 0.00 | 0.00 | 819.46 | 0.00 |
| Nelson, James, L,24525 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Kapoor, Preston,21431 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 39.47 | 218.68 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Cox, Devin, C,13418 | 4768.05 | 0.00 | 0.00 | 0.00 | 4768.05 |
| Sanders, Angel,16219 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
| Wilson, Hunter, R,27230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Wang, Benjamin, R,27454 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gonzales, Kayla,21494 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramirez, Garrett, M,17388 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Van, Bobby,27757 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
| Cooper, Amanda, P,14606 | 4716.02 | 0.00 | 0.00 | 0.00 | 4716.02 |
| Stewart, Destiny,13144 | 281.47 | 0.00 | 0.00 | 134.98 | 146.49 |
| Chen, Jackson, S,27075 | 1371.95 | 0.00 | 782.99 | 0.00 | 588.96 |
| Campbell, Adam, A,21400 | 2688.89 | 0.00 | 0.00 | 2071.42 | 617.47 |
| Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Mitchell, Savannah,26115 | 3052.80 | 0.00 | 0.00 | 2443.35 | 609.45 |
| Mitchell, Kaylee, R,14566 | 401.49 | 0.00 | 0.00 | 0.00 | 401.49 |
| Sanders, Isaiah,25873 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Young, Courtney,17622 | 2374.98 | 0.00 | 0.00 | 0.00 | 2374.98 |
| Martin, Alfredo, P,21480 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Parker, Kaylee, M,27738 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Carter, Jesse, E,22141 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Rivera, Caitlin, L,26113 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
| Cook, Steven, J,27053 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Simmons, Jose,24647 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 86.48 | 912.74 |
| Peterson, Isabella,28080 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jones, Michael, A,22107 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Brown, Samantha, G,25147 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martin, Jill, C,11824 | 181.03 | 0.00 | 0.00 | 69.97 | 111.06 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Ward, Eduardo, I,13916 | 2354.98 | 0.00 | 0.00 | 0.00 | 2354.98 |
| Bennett, Brittany, J,22332 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Hernandez, Marcus,18595 | 2329.99 | 0.00 | 0.00 | 0.00 | 2329.99 |
| Hall, Wyatt,23827 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 99.97 | 126.46 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Ramos, Kristi,15176 | 4703.03 | 0.00 | 0.00 | 0.00 | 4703.03 |
| Butler, Jackson, J,18324 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Robinson, William,20103 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 123.98 | 213.92 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 84.96 | 70.95 |
| Hughes, Isabella,23048 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| Gonzales, Jasmine, C,18392 | 2342.93 | 0.00 | 0.00 | 0.00 | 2342.93 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 0.00 | 287.70 |
| Richardson, Evan, J,15488 | 165.30 | 0.00 | 0.00 | 0.00 | 165.30 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 93.56 | 14.98 |
| Garcia, Lucas,27545 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ruiz, Philip,18077 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Bailey, Mariah, L,27243 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Mr., Sandstone, John, J,12903 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
| Harris, Samantha, A,24487 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hughes, Riley,29284 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Cooper, Andrea,29323 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Davis, Austin, E,13366 | 4749.04 | 0.00 | 0.00 | 0.00 | 4749.04 |
| Parker, Morgan, S,16772 | 36.96 | 0.00 | 0.00 | 14.98 | 21.98 |
Generated 2025-11-01 00:04:45.179 UTC