[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 >
125 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Parker, James,11808 | 610.19 | 0.00 | 0.00 | 351.22 | 258.97 |
Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
Chandra, Brandy, P,11501 | 603.53 | 0.00 | 0.00 | 128.21 | 475.32 |
Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
Powell, Jasmine, A,11505 | 846.77 | 0.00 | 0.00 | 441.44 | 405.33 |
Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 42.28 | 189.95 |
Turner, Kaylee, M,16213 | 154.54 | 0.00 | 0.00 | 0.00 | 154.54 |
Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 71.58 | 124.69 |
Reed, Kaylee, R,17371 | 151.92 | 0.00 | 0.00 | 0.00 | 151.92 |
Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
Collins, Hailey,11709 | 325.89 | 0.00 | 0.00 | 91.48 | 234.41 |
Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
Barnes, Fernando,11300 | 1390.55 | 0.00 | 0.00 | 283.37 | 1107.18 |
Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
Parker, Jordan,21621 | 2616.86 | 0.00 | 0.00 | 2049.10 | 567.76 |
Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 181.91 | 463.87 |
Garcia, Henry, B,11287 | 1009.24 | 0.00 | 0.00 | 283.45 | 725.79 |
Clark, Lauren,17034 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Brown, Julia,18065 | 155.47 | 0.00 | 0.00 | 0.00 | 155.47 |
Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
Nath, Kenneth, W,17037 | 2334.97 | 0.00 | 0.00 | 0.00 | 2334.97 |
Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 262.78 | 1118.59 |
Simmons, Jennifer,11262 | 1010.56 | 0.00 | 0.00 | 226.90 | 783.66 |
Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Sandberg, Chase,21904 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
Bell, Danielle,14041 | 4765.02 | 0.00 | 0.00 | 2351.96 | 2413.06 |
Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
Jackson, Charles, P,11277 | 1305.66 | 0.00 | 0.00 | 511.23 | 794.43 |
Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 94.48 | 192.72 |
Thomas, Zachary, D,28045 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
Hughes, Antonio, P,15913 | 712.27 | 0.00 | 0.00 | 712.27 | 0.00 |
King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Foster, Carson, L,16959 | 135.35 | 0.00 | 0.00 | 120.37 | 14.98 |
Allen, Luke,11316 | 2349.98 | 0.00 | 0.00 | 2349.98 | 0.00 |
Miller, Victoria,15816 | 188.02 | 0.00 | 0.00 | 118.05 | 69.97 |
Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
Gonzalez, Amber, L,23879 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
Henderson, Justin, P,23591 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
Griffin, Seth, R,17585 | 164.46 | 0.00 | 0.00 | 78.98 | 85.48 |
Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
Taylor, Taylor,15905 | 4899.02 | 0.00 | 0.00 | 0.00 | 4899.02 |
Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 194.86 | 328.95 |
Nath, Carl, H,29001 | 624.97 | 0.00 | 0.00 | 0.00 | 624.97 |
Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
Perry, Jackson, J,21306 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
Ramirez, Gabrielle, H,16000 | 4813.95 | 0.00 | 0.00 | 0.00 | 4813.95 |
Diaz, Hailey, W,11693 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
Williams, Ethan,24309 | 4793.12 | 0.00 | 3578.27 | 0.00 | 1214.85 |
Davis, Thomas,16764 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
Thompson, Abigail,24332 | 4816.09 | 0.00 | 3578.27 | 0.00 | 1237.82 |
Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 300.89 | 402.10 |
Walker, Brandon, J,15916 | 4793.27 | 0.00 | 0.00 | 0.00 | 4793.27 |
Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 542.74 | 747.59 |
Martin, Kellie, R,28195 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
Anderson, Madison, G,28359 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
Cox, Arianna, D,18927 | 89.25 | 0.00 | 0.00 | 0.00 | 89.25 |
Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 73.97 | 13.98 |
Hill, Blake,11748 | 131.54 | 0.00 | 0.00 | 0.00 | 131.54 |
Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Chandra, Allen,29327 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 465.56 | 690.34 |
Nelson, Katherine,28021 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 155.22 | 496.76 |
Butler, Dalton, A,13345 | 4759.51 | 0.00 | 0.00 | 0.00 | 4759.51 |
Thomas, Logan, A,14091 | 251.20 | 0.00 | 0.00 | 53.99 | 197.21 |
Simmons, Haley, T,26202 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
Bailey, Jessica, L,12945 | 218.44 | 0.00 | 0.00 | 0.00 | 218.44 |
Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 39.99 | 124.22 |
Gutierrez, Neil, L,21489 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
Sanders, Sean,14341 | 175.15 | 0.00 | 0.00 | 0.00 | 175.15 |
Price, Devin, M,18758 | 158.51 | 0.00 | 0.00 | 73.55 | 84.96 |
Roberts, Amanda,17175 | 2334.98 | 0.00 | 0.00 | 0.00 | 2334.98 |
Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 173.39 | 384.15 |
Campbell, Chloe,11212 | 760.93 | 0.00 | 0.00 | 307.78 | 453.15 |
Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 266.33 | 441.17 |
Lee, William,13185 | 149.84 | 0.00 | 0.00 | 74.96 | 74.88 |
Rogers, Andrea, L,14328 | 308.66 | 0.00 | 0.00 | 155.23 | 153.43 |
Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
Russell, Samantha,11211 | 723.56 | 0.00 | 0.00 | 249.40 | 474.16 |
Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
Johnson, Jonathan,22059 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 154.98 | 210.43 |
Gonzalez, Jordan,15157 | 213.94 | 0.00 | 0.00 | 198.96 | 14.98 |
Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
Jones, Kayla, C,18541 | 94.26 | 0.00 | 0.00 | 69.99 | 24.27 |
Sanders, Isaiah,25873 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Bailey, Lauren,15864 | 103.55 | 0.00 | 0.00 | 9.99 | 93.56 |
Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
Brown, Anna,16247 | 95.82 | 0.00 | 0.00 | 0.00 | 95.82 |
Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
Russell, Richard,27633 | 22.26 | 0.00 | 0.00 | 0.00 | 22.26 |
Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 93.56 | 14.98 |
Cannata, Gabrielle, C,21725 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 610.74 | 656.37 |
Chen, Jack, E,17579 | 151.43 | 0.00 | 0.00 | 0.00 | 151.43 |
Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 76.97 | 69.97 |
Jones, Natalie, A,11845 | 197.20 | 0.00 | 0.00 | 82.26 | 114.94 |
Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
Rodriguez, Taylor,16071 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 116.44 | 32.60 |
Turner, Morgan,11823 | 178.47 | 0.00 | 0.00 | 0.00 | 178.47 |
Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
Brooks, Evan,23401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
Johnson, Cameron, R,13720 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
Gray, Isabella,16820 | 3217.79 | 0.00 | 0.00 | 0.00 | 3217.79 |
Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 127.28 | 0.00 |
Peterson, Julia, P,16497 | 132.71 | 0.00 | 0.00 | 0.00 | 132.71 |
Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
Lewis, Zachary, L,14760 | 167.26 | 0.00 | 0.00 | 0.00 | 167.26 |
Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
Butler, Jonathan,26180 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2024-09-19 21:44:53.360 UTC