[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Wang, Zachary,22144 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Bell, Alex, M,16754 | 3118.60 | 0.00 | 0.00 | 756.33 | 2362.27 |
| Lopez, Jack, I,29047 | 51.46 | 0.00 | 0.00 | 0.00 | 51.46 |
| Torres, Christina, M,20746 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Gonzales, Arianna, S,19710 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| Washington, Miranda,15201 | 4793.02 | 0.00 | 0.00 | 0.00 | 4793.02 |
| Moore, Anthony, M,24730 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Kevin,15878 | 225.92 | 0.00 | 0.00 | 69.97 | 155.95 |
| Griffin, Miguel,21464 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Henderson, Sarah, M,23867 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Taylor, Natalie, M,14338 | 828.74 | 0.00 | 0.00 | 0.00 | 828.74 |
| Mehta, Carmen, C,27436 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Perez, Amber, D,13318 | 214.26 | 0.00 | 0.00 | 116.91 | 97.35 |
| Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Turner, Jeremiah, F,19207 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Anand, Brendan, L,19847 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Bailey, Alexandria, V,13209 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Prasad, Erick, E,28786 | 127.95 | 0.00 | 0.00 | 0.00 | 127.95 |
| Flores, Jordyn,25288 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Mitchell, Thomas, J,13711 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 |
| Watson, Devin, A,18875 | 114.95 | 0.00 | 0.00 | 0.00 | 114.95 |
| King, Gabrielle,26350 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Hailey,15507 | 267.84 | 0.00 | 0.00 | 228.96 | 38.88 |
| Moore, Wyatt, F,18971 | 2351.96 | 0.00 | 0.00 | 0.00 | 2351.96 |
| James, Zoe, R,14611 | 304.55 | 0.00 | 0.00 | 0.00 | 304.55 |
| Williams, Austin,20354 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Carter, Jesse, E,22141 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Ward, Cole,21490 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Destiny, M,13710 | 2341.46 | 0.00 | 0.00 | 0.00 | 2341.46 |
| Hall, Charles,23476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wilson, Jeremy, T,28341 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Nath, Kenneth, W,17037 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
| Howard, Brianna, D,24630 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Parker, Amanda,18081 | 51.97 | 0.00 | 0.00 | 0.00 | 51.97 |
| Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
| Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Martin, Thomas, A,16952 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cannata, Gabrielle, C,21725 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Simmons, Nicole, S,26177 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Reed, Kaitlyn, H,27413 | 103.48 | 0.00 | 0.00 | 0.00 | 103.48 |
| Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
| Murphy, Eduardo, S,16124 | 614.45 | 0.00 | 0.00 | 0.00 | 614.45 |
| Moreno, Lance, A,29229 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Flores, Megan, N,23074 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Shan, Chad, M,24621 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Gutierrez, Linda, D,28575 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Coleman, Benjamin, F,23486 | 5343.23 | 0.00 | 3578.27 | 0.00 | 1764.96 |
| She, Shawn, J,16902 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Peterson, Xavier, R,26456 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Anderson, Megan, A,23859 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martinez, Carol, D,17656 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Flores, Miguel,19750 | 77.25 | 0.00 | 0.00 | 0.00 | 77.25 |
| Martin, Brianna, M,23583 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Watson, Janet, S,23208 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Murphy, Maria,16011 | 3657.26 | 0.00 | 0.00 | 0.00 | 3657.26 |
| Sanchez, Nicole, L,14874 | 804.48 | 0.00 | 0.00 | 0.00 | 804.48 |
| Peterson, Gabrielle, D,24310 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Clark, William,29021 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Kennedy, Bridget,22026 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lewis, Ethan,27998 | 144.47 | 0.00 | 0.00 | 0.00 | 144.47 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Lopez, Isaiah,18968 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
| Griffin, Marcus,20756 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Edwards, Elijah, D,28157 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Allen, Aaron, A,20075 | 3399.99 | 0.00 | 3399.99 | 0.00 | 0.00 |
| Johnson, Edward, H,23279 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 |
| Alexander, Sarah,19411 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Griffin, Stephanie, L,28261 | 27.92 | 0.00 | 0.00 | 0.00 | 27.92 |
| Blue, Melanie, L,17861 | 1749.96 | 0.00 | 0.00 | 0.00 | 1749.96 |
| Harris, Joshua, L,20280 | 95.94 | 0.00 | 0.00 | 30.97 | 64.97 |
| Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
| Washington, Robert, J,14906 | 143.95 | 0.00 | 0.00 | 0.00 | 143.95 |
| Alexander, Jordan,21412 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Taylor, Lucas, V,11523 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
| Walker, Isabella,24386 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Green, Eric,27380 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Washington, Hannah, A,29130 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Morris, Jessica,28967 | 8.99 | 0.00 | 0.00 | 8.99 | 0.00 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
| Lee, James, J,28817 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| She, Alisha, G,24757 | 4343.59 | 0.00 | 3578.27 | 0.00 | 765.32 |
| Barnes, Kaitlyn, Z,15162 | 154.96 | 0.00 | 0.00 | 0.00 | 154.96 |
| Hernandez, Jamie,27283 | 119.98 | 0.00 | 0.00 | 119.98 | 0.00 |
| Walker, Ian,16771 | 104.55 | 0.00 | 0.00 | 54.58 | 49.97 |
| Long, Caleb, P,25046 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Cook, Seth,23010 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Jai, Luis, A,18320 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Foster, Alyssa, I,14875 | 839.48 | 0.00 | 0.00 | 0.00 | 839.48 |
| Garcia, Carmen, J,24781 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Simmons, Elizabeth, A,21461 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Flores, Hannah,19525 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Lee, Kayla, M,20781 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Wood, Alexandria, M,24824 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
| Zhao, Clarence, R,19826 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Sanders, Mason, G,23459 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Adams, Haley, M,24786 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Kumar, Zachary,25433 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Bailey, R,18557 | 1179.47 | 0.00 | 0.00 | 1179.47 | 0.00 |
| Edwards, Alexandra,13358 | 2386.94 | 0.00 | 0.00 | 0.00 | 2386.94 |
| Richardson, Victoria, C,24817 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Zhao, Karen, L,25408 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Wilson, Emily,17400 | 2331.95 | 0.00 | 0.00 | 0.00 | 2331.95 |
| Gray, Cindy, A,13198 | 114.95 | 0.00 | 0.00 | 99.97 | 14.98 |
| Jai, Adam,25095 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 56.97 | 119.98 |
| Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Brandon,23676 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Huang, Kristen,25100 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Long, Sarah,17372 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| Edwards, Hunter,24220 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| White, Jennifer, S,27027 | 782.99 | 0.00 | 782.99 | 0.00 | 0.00 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Martinez, Joseph, E,29214 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Hayes, Dalton, C,18882 | 2322.28 | 0.00 | 0.00 | 0.00 | 2322.28 |
Generated 2024-11-10 08:55:25.197 UTC