[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 625 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Martin, Gina, E,11078 | 793.27 | 0.00 | 0.00 | 158.36 | 634.91 |
| Russell, Fernando,27084 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bradley, Rachel,15850 | 4813.04 | 0.00 | 0.00 | 0.00 | 4813.04 |
| Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 39.99 | 124.22 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Ramos, Derrick,18449 | 100.94 | 0.00 | 0.00 | 30.97 | 69.97 |
| Peterson, Melissa, S,24995 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Carter, Savannah, M,12090 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Torres, Xavier,16840 | 176.95 | 0.00 | 0.00 | 0.00 | 176.95 |
| Ross, Elizabeth, E,14118 | 4741.34 | 0.00 | 0.00 | 0.00 | 4741.34 |
| Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 28.48 | 617.30 |
| Sanders, Xavier,16721 | 73.75 | 0.00 | 0.00 | 0.00 | 73.75 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Morgan, Abigail, C,24431 | 4334.60 | 0.00 | 3578.27 | 0.00 | 756.33 |
| Hall, Noah, A,15251 | 75.25 | 0.00 | 0.00 | 0.00 | 75.25 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Perry, Marcus, L,20656 | 3245.90 | 0.00 | 0.00 | 2071.42 | 1174.48 |
| Williams, Morgan, C,20373 | 3226.90 | 0.00 | 0.00 | 2071.42 | 1155.48 |
| Sandberg, Isaac,13350 | 53.97 | 0.00 | 0.00 | 0.00 | 53.97 |
| Garcia, Brandon, V,24418 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Hill, Katherine, L,26701 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Hailey, C,17148 | 1775.47 | 0.00 | 0.00 | 0.00 | 1775.47 |
| Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 410.31 | 880.02 |
| Butler, Victoria,13284 | 4767.53 | 0.00 | 0.00 | 0.00 | 4767.53 |
| Brown, Fernando,19001 | 91.95 | 0.00 | 0.00 | 69.97 | 21.98 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 37.27 | 202.33 |
| Parker, Jennifer, D,22118 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Gray, Seth, M,20087 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Sanz, Lori, L,23865 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Bailey, Richard, N,22050 | 4160.53 | 3578.27 | 0.00 | 0.00 | 582.26 |
| Price, Miranda,26629 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Rodriguez, Morgan,23730 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Bradley, Jocelyn,23022 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Sanders, Alexandra,25911 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Carter, Marcus, l,21471 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Chen, James, D,11641 | 303.20 | 0.00 | 0.00 | 21.49 | 281.71 |
| Green, Samuel, D,14096 | 174.73 | 0.00 | 0.00 | 0.00 | 174.73 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 133.96 | 84.95 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Gonzalez, Katherine,22234 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Powell, Caleb, G,21613 | 2610.58 | 0.00 | 0.00 | 2049.10 | 561.48 |
| Perry, Jonathan, T,27026 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hughes, Edward,20023 | 4530.47 | 0.00 | 3374.99 | 0.00 | 1155.48 |
| Wilson, Madison, H,19828 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bailey, Hailey, R,26270 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lee, Emma,16948 | 176.43 | 0.00 | 0.00 | 0.00 | 176.43 |
| Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 60.47 | 172.24 |
| Reed, Megan, A,18118 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Wood, Gabrielle, S,28787 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Hughes, Zachary,12203 | 157.91 | 0.00 | 0.00 | 0.00 | 157.91 |
| Miller, Alexis, A,12196 | 124.93 | 0.00 | 0.00 | 0.00 | 124.93 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Jones, Michael, A,22107 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Alexander, Lauren,18950 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Reed, Bryan,18884 | 133.93 | 0.00 | 0.00 | 0.00 | 133.93 |
| Simmons, Dakota, T,14110 | 819.46 | 0.00 | 0.00 | 0.00 | 819.46 |
| Gonzales, Jose,22014 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| James, Julia,24975 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Griffin, Haley, L,18925 | 82.18 | 0.00 | 0.00 | 0.00 | 82.18 |
| Gray, Jared, A,26449 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Alexander, Edward, E,18524 | 195.95 | 0.00 | 0.00 | 0.00 | 195.95 |
| Jones, Joshua,18401 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Fernandez, Darren,28992 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Smith, Samuel, D,23083 | 49.90 | 0.00 | 0.00 | 0.00 | 49.90 |
| Coleman, Miguel, D,27400 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 148.47 | 364.00 |
| Smith, Zachary, W,23783 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Thompson, Ethan,19989 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Long, Brandon, M,16110 | 650.47 | 0.00 | 0.00 | 0.00 | 650.47 |
| Baker, Robert, A,27300 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Russell, Nicole, M,18237 | 2318.96 | 0.00 | 0.00 | 0.00 | 2318.96 |
| Cook, Joan,23554 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Paige,14119 | 148.94 | 0.00 | 0.00 | 0.00 | 148.94 |
| Butler, Morgan, E,20500 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Johnson, Xavier, R,23255 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Lal, Jonathan,20096 | 71.46 | 0.00 | 0.00 | 0.00 | 71.46 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| White, Greg, C,17403 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
| Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Ross, Anna, D,15494 | 275.44 | 0.00 | 0.00 | 29.99 | 245.45 |
| Hayes, Gavin, A,19400 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Washington, Kayla, E,14655 | 174.96 | 0.00 | 0.00 | 69.97 | 104.99 |
| Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Watson, Victoria,16125 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Thomas, A,16952 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Green, Xavier,23567 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Johnson, Jacob, I,28069 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Parker, Natalie, A,25104 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Parker, Kaylee, M,27738 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 71.58 | 170.92 |
| Roberts, Wyatt,15900 | 699.97 | 0.00 | 0.00 | 699.97 | 0.00 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Harrison, Trevor, A,18055 | 143.91 | 0.00 | 0.00 | 36.96 | 106.95 |
| Flores, Caleb, S,12165 | 280.64 | 0.00 | 0.00 | 243.37 | 37.27 |
| Reed, Paige,22112 | 6047.32 | 3578.27 | 0.00 | 2469.05 | 0.00 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 58.47 | 240.02 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Kelly, Trinity,26095 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Torres, Christina, M,20746 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Jackson, Elizabeth, K,16837 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
| He, Micah,27401 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Generated 2025-11-03 15:19:57.286 UTC