[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 61 SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Stewart, Gabriella,28034 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rodriguez, Natalie,20773 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Patterson, Cassidy, A,17586 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Russell, Kaitlyn, M,24491 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Ross, Antonio,18322 | 148.89 | 0.00 | 0.00 | 0.00 | 148.89 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Blue, Melanie, L,17861 | 1749.96 | 0.00 | 0.00 | 0.00 | 1749.96 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Phillips, Jackson, D,23378 | 5317.23 | 0.00 | 3578.27 | 0.00 | 1738.96 |
| Mitchell, Katelyn, A,24496 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
| Wright, Katelyn, A,14502 | 122.26 | 0.00 | 0.00 | 0.00 | 122.26 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Bailey, Morgan, E,21354 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Patterson, Eric, A,27384 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Stewart, Marcus, R,20632 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Peterson, Morgan, J,16834 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
| Baker, Sara, M,11827 | 512.47 | 0.00 | 0.00 | 0.00 | 512.47 |
| Price, Oscar, G,11833 | 240.01 | 0.00 | 0.00 | 0.00 | 240.01 |
| Roberts, Jordan, M,16800 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Baker, Isaiah,12106 | 169.54 | 0.00 | 0.00 | 0.00 | 169.54 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Roberts, Thomas, J,21939 | 4163.24 | 0.00 | 3578.27 | 0.00 | 584.97 |
| Flores, Emily,13206 | 163.19 | 0.00 | 0.00 | 0.00 | 163.19 |
| Howard, Danielle,28357 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Robinson, Madison, W,18377 | 2394.97 | 0.00 | 0.00 | 0.00 | 2394.97 |
| Gonzalez, Gabriella, Z,15872 | 235.54 | 0.00 | 0.00 | 0.00 | 235.54 |
| Morris, Seth,18959 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Edwards, Logan,25002 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Trevor,27415 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Kumar, Austin,20483 | 4400.06 | 0.00 | 0.00 | 2049.10 | 2350.96 |
| Nelson, Henry,19394 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Long, Gabrielle,19830 | 5765.92 | 0.00 | 3374.99 | 0.00 | 2390.93 |
| Ms., Coleman, Abigail, C,23868 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Simmons, Jose,24647 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| White, Christopher, R,26049 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Parker, Katherine,13268 | 289.70 | 0.00 | 0.00 | 0.00 | 289.70 |
| Washington, Victoria,23557 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Baker, Sean, T,24778 | 2858.49 | 0.00 | 2181.56 | 0.00 | 676.93 |
| Rogers, Carlos,19645 | 134.44 | 0.00 | 0.00 | 0.00 | 134.44 |
| Watson, Emma,17481 | 126.94 | 0.00 | 0.00 | 0.00 | 126.94 |
| Foster, Nicole, A,23494 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Perry, Christian,24671 | 4354.60 | 0.00 | 3578.27 | 0.00 | 776.33 |
| Long, Jordyn,17338 | 47.25 | 0.00 | 0.00 | 0.00 | 47.25 |
| Chander, Wayne, S,24344 | 4329.61 | 0.00 | 3578.27 | 0.00 | 751.34 |
| Griffin, Xavier,22877 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Thompson, Madison, L,18788 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Ramirez, Ian,16678 | 3162.31 | 0.00 | 0.00 | 0.00 | 3162.31 |
| Perez, Dalton,11091 | 1125.36 | 0.00 | 0.00 | 13.98 | 1111.38 |
| Perez, Angel, S,21336 | 2628.35 | 0.00 | 0.00 | 2071.42 | 556.93 |
| Adams, Julia, N,26073 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rivera, Allison, M,13751 | 224.91 | 0.00 | 0.00 | 0.00 | 224.91 |
| Powell, Katherine, C,14574 | 177.60 | 0.00 | 0.00 | 0.00 | 177.60 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Charles,25094 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Henderson, Olivia,18859 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hill, Eric, G,25256 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Foster, Abigail,19823 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Brooks, Jacqueline, W,28254 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Garcia, Cameron,18641 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Gonzales, Emily, P,21777 | 180.98 | 0.00 | 0.00 | 0.00 | 180.98 |
| Anderson, Lucas,29266 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Barnes, Dalton, C,17858 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Rivera, Kaitlyn, R,15490 | 4813.52 | 0.00 | 0.00 | 0.00 | 4813.52 |
| Roberts, Noah, S,27042 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Hughes, Luke, I,27014 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Harris, Jeremiah, B,17023 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 0.00 | 100.84 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 0.00 | 298.49 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Wilson, Victoria, R,27536 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Bennett, Maria, G,22983 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramirez, Emma,29072 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Patterson, Alexis,21348 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Perez, Jordan, A,29267 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rodriguez, Nicholas, D,14604 | 137.95 | 0.00 | 0.00 | 23.97 | 113.98 |
| Nelson, Jordan, H,20130 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| Wright, Jackson,11698 | 225.95 | 0.00 | 0.00 | 0.00 | 225.95 |
| Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
| Hayes, Oscar,26527 | 29.26 | 0.00 | 0.00 | 0.00 | 29.26 |
| Mitchell, Kaylee, R,14566 | 401.49 | 0.00 | 0.00 | 0.00 | 401.49 |
| Gill, Beth,19997 | 5814.98 | 0.00 | 3374.99 | 0.00 | 2439.99 |
| Cooper, Brian, L,13760 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| White, Nicole,16731 | 155.91 | 0.00 | 0.00 | 0.00 | 155.91 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Prasad, Donald,15413 | 318.92 | 0.00 | 0.00 | 123.98 | 194.94 |
| Lobao, Alexandre,18926 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 31.27 | 808.88 |
| Carter, Elijah,21618 | 2611.07 | 0.00 | 0.00 | 2611.07 | 0.00 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Moreno, Meredith, D,22285 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Lewis, Lucas, A,23209 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
| Long, Gavin,13762 | 186.03 | 0.00 | 0.00 | 0.00 | 186.03 |
| Griffin, Isabelle,24986 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Caleb, R,15868 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 21.98 | 86.56 |
| Campbell, Timothy,25845 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Allen, Amanda,22353 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Brown, Fernando,19001 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Wilson, Eduardo,15323 | 804.47 | 0.00 | 0.00 | 0.00 | 804.47 |
| Wagner, Alexandra, E,23244 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Powell, Lauren, E,19662 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Li, Thomas,18116 | 2376.96 | 0.00 | 0.00 | 0.00 | 2376.96 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Chavez, Kara, P,13285 | 214.35 | 0.00 | 0.00 | 0.00 | 214.35 |
| Li, Eugene, A,15283 | 865.95 | 0.00 | 0.00 | 0.00 | 865.95 |
| Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Hernandez, José, M,11253 | 696.61 | 0.00 | 0.00 | 0.00 | 696.61 |
| Gray, Jesse,14626 | 197.04 | 0.00 | 0.00 | 0.00 | 197.04 |
| Adams, Kaitlyn, A,11869 | 239.60 | 0.00 | 0.00 | 0.00 | 239.60 |
Generated 2025-12-23 11:52:20.687 UTC