[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 124 >
124 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Phillips, Devin,18759 | 112.06 | 0.00 | 0.00 | 0.00 | 112.06 |
Murphy, Chase, J,24729 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
Kelly, Angel, E,15418 | 232.23 | 0.00 | 0.00 | 42.28 | 189.95 |
Moore, Hunter,14897 | 196.27 | 0.00 | 0.00 | 71.58 | 124.69 |
Robinson, Dylan, L,14724 | 81.53 | 0.00 | 0.00 | 0.00 | 81.53 |
Davis, Ethan,13660 | 4750.01 | 0.00 | 0.00 | 0.00 | 4750.01 |
Long, Kaitlyn,23396 | 4891.61 | 0.00 | 3578.27 | 0.00 | 1313.34 |
Russell, Isabella, A,11507 | 645.78 | 0.00 | 0.00 | 181.91 | 463.87 |
Clark, Lauren,17034 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
Gutierrez, Jerome,12783 | 2420.46 | 0.00 | 0.00 | 0.00 | 2420.46 |
Henderson, Ashley,11185 | 1381.37 | 0.00 | 0.00 | 262.78 | 1118.59 |
Scott, Gabrielle,27061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Ward, Devin, J,15378 | 170.91 | 0.00 | 0.00 | 76.95 | 93.96 |
Washington, Thomas, C,27451 | 37.43 | 0.00 | 0.00 | 0.00 | 37.43 |
Green, Blake, P,11719 | 287.20 | 0.00 | 0.00 | 94.48 | 192.72 |
Townsend, Bryan,14077 | 180.73 | 0.00 | 0.00 | 0.00 | 180.73 |
King, Caleb, J,28986 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Davis, Thomas,16764 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
Morgan, Jada, A,11520 | 702.99 | 0.00 | 0.00 | 300.89 | 402.10 |
Jenkins, Samantha,11331 | 1290.33 | 0.00 | 0.00 | 542.74 | 747.59 |
Young, Adam,12984 | 200.20 | 0.00 | 0.00 | 107.26 | 92.94 |
Wilson, Nathan, L,13936 | 218.93 | 0.00 | 0.00 | 0.00 | 218.93 |
Jai, Samuel, L,16358 | 87.95 | 0.00 | 0.00 | 73.97 | 13.98 |
Green, Mackenzie, C,28073 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Allen, Luke,11316 | 2349.98 | 0.00 | 0.00 | 2349.98 | 0.00 |
Alexander, Luke,29043 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
Nelson, Sierra,16132 | 2459.62 | 0.00 | 0.00 | 2459.62 | 0.00 |
Alexander, Ryan, J,14078 | 839.48 | 0.00 | 0.00 | 839.48 | 0.00 |
Diaz, Jasmine, A,16098 | 3101.29 | 0.00 | 0.00 | 756.33 | 2344.96 |
Martinez, Andrew, C,11530 | 523.81 | 0.00 | 0.00 | 194.86 | 328.95 |
Thomas, Seth,14567 | 161.28 | 0.00 | 0.00 | 96.07 | 65.21 |
Stewart, Timothy, F,13199 | 105.19 | 0.00 | 0.00 | 22.93 | 82.26 |
Diaz, Hailey, W,11693 | 2294.99 | 0.00 | 0.00 | 2294.99 | 0.00 |
Collins, Xavier, C,16646 | 250.91 | 0.00 | 0.00 | 0.00 | 250.91 |
Sanders, Isaiah,25873 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Patterson, Hailey, I,11223 | 1155.90 | 0.00 | 0.00 | 465.56 | 690.34 |
Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 155.22 | 496.76 |
Thomas, Logan, A,14091 | 251.20 | 0.00 | 0.00 | 53.99 | 197.21 |
Wedge, Andrew, T,12060 | 4811.54 | 0.00 | 0.00 | 2418.48 | 2393.06 |
Jai, Jose,12944 | 164.21 | 0.00 | 0.00 | 39.99 | 124.22 |
Flores, Devin, A,15559 | 172.04 | 0.00 | 0.00 | 86.56 | 85.48 |
Price, Devin, M,18758 | 158.51 | 0.00 | 0.00 | 73.55 | 84.96 |
Sun, Arturo, C,11498 | 557.54 | 0.00 | 0.00 | 173.39 | 384.15 |
Hu, Gilbert, L,28767 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
Lee, William,13185 | 149.84 | 0.00 | 0.00 | 74.96 | 74.88 |
Carter, Isaac,13719 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
Lal, Kyle,17360 | 122.18 | 0.00 | 0.00 | 0.00 | 122.18 |
Watson, Richard,15943 | 365.41 | 0.00 | 0.00 | 154.98 | 210.43 |
Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 93.56 | 14.98 |
Morgan, Andrea, M,16870 | 149.04 | 0.00 | 0.00 | 116.44 | 32.60 |
Russell, Ian, T,24746 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
Diaz, Katherine, P,11526 | 2376.96 | 0.00 | 0.00 | 2376.96 | 0.00 |
Evans, Maria,22544 | 127.28 | 0.00 | 0.00 | 127.28 | 0.00 |
Yuan, Yolanda, C,22154 | 36.96 | 0.00 | 0.00 | 36.96 | 0.00 |
Thompson, Xavier, R,15761 | 192.41 | 0.00 | 0.00 | 0.00 | 192.41 |
Zhang, Nathan, L,29104 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Cooper, Timothy, J,20651 | 3198.57 | 0.00 | 0.00 | 2049.10 | 1149.47 |
Thomas, Wyatt, R,12431 | 154.54 | 0.00 | 0.00 | 94.98 | 59.56 |
Dominguez, Erika, C,21251 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
Taylor, Christian,20764 | 56.76 | 0.00 | 0.00 | 0.00 | 56.76 |
Campbell, Hunter,17422 | 174.92 | 0.00 | 0.00 | 0.00 | 174.92 |
Griffin, Jason, L,11200 | 1267.11 | 0.00 | 0.00 | 610.74 | 656.37 |
Alexander, Taylor,17482 | 146.94 | 0.00 | 0.00 | 76.97 | 69.97 |
Jackson, Hannah, G,13143 | 2404.97 | 0.00 | 0.00 | 0.00 | 2404.97 |
Hughes, Eduardo,15564 | 188.52 | 0.00 | 0.00 | 0.00 | 188.52 |
Walker, Thomas,13071 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 |
Phillips, Luis, G,20734 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Henderson, Jackson, A,22121 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
Rodriguez, Alexis, L,15244 | 179.19 | 0.00 | 0.00 | 42.28 | 136.91 |
Sanders, Hailey,19647 | 282.04 | 0.00 | 0.00 | 39.98 | 242.06 |
Ruiz, Philip,18077 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
Perez, Savannah, J,17036 | 176.95 | 0.00 | 0.00 | 56.97 | 119.98 |
Ross, Jose,27441 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
Gonzales, Trevor, K,16085 | 143.53 | 0.00 | 0.00 | 14.98 | 128.55 |
Torres, Taylor,16666 | 205.44 | 0.00 | 0.00 | 123.98 | 81.46 |
Alexander, Paige, W,18604 | 59.25 | 0.00 | 0.00 | 37.27 | 21.98 |
Lopez, Katelyn,11820 | 232.71 | 0.00 | 0.00 | 92.74 | 139.97 |
Carter, Bailey,21332 | 2616.86 | 0.00 | 0.00 | 2616.86 | 0.00 |
Phillips, Isaiah,28631 | 144.47 | 0.00 | 0.00 | 144.47 | 0.00 |
Mr., Smith, Jeff,29283 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
Robinson, Emily,12183 | 228.42 | 0.00 | 0.00 | 54.96 | 173.46 |
Rodriguez, Richard,12969 | 180.79 | 0.00 | 0.00 | 0.00 | 180.79 |
Martin, Nicholas,23362 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Roberts, Seth, H,11510 | 258.15 | 0.00 | 0.00 | 39.47 | 218.68 |
Sanders, Melissa, R,24284 | 4837.34 | 0.00 | 3578.27 | 0.00 | 1259.07 |
Phillips, Kyle,12158 | 202.20 | 0.00 | 0.00 | 0.00 | 202.20 |
Thomas, Benjamin, J,21295 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
Campbell, Isabella, C,20350 | 3226.90 | 0.00 | 2071.42 | 0.00 | 1155.48 |
Bradley, Alexandria,17691 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
Smith, Samuel, D,23083 | 49.90 | 0.00 | 0.00 | 0.00 | 49.90 |
Brown, Fernando,19001 | 91.95 | 0.00 | 0.00 | 69.97 | 21.98 |
Nelson, Jennifer,17147 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
Collins, Alex, S,28781 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
Bryant, Brittany,22545 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
Henderson, Logan, C,22366 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
Miller, Sydney, A,13440 | 4818.53 | 0.00 | 0.00 | 0.00 | 4818.53 |
Xu, Louis,20104 | 66.53 | 0.00 | 0.00 | 66.53 | 0.00 |
Rodriguez, Destiny, J,22739 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
Diaz, Ryan, J,16910 | 141.96 | 0.00 | 0.00 | 71.97 | 69.99 |
Miller, Chloe, V,22893 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
Chen, Jonathan, G,13096 | 200.69 | 0.00 | 0.00 | 0.00 | 200.69 |
Smith, Noah,13175 | 166.92 | 0.00 | 0.00 | 0.00 | 166.92 |
Henderson, Isabelle, K,16366 | 2563.35 | 0.00 | 0.00 | 0.00 | 2563.35 |
Cox, Nathaniel, A,19661 | 2521.27 | 0.00 | 0.00 | 0.00 | 2521.27 |
Mitchell, Katelyn, A,24496 | 4349.61 | 0.00 | 3578.27 | 0.00 | 771.34 |
Thames, Bernard,23803 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
Sanders, Allison, B,18852 | 268.25 | 0.00 | 0.00 | 0.00 | 268.25 |
Hall, Fernando,22100 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
Rodriguez, Michael, E,16810 | 3064.63 | 0.00 | 0.00 | 0.00 | 3064.63 |
Foster, Isabel, M,21745 | 71.95 | 0.00 | 0.00 | 0.00 | 71.95 |
Johnson, Christopher,11979 | 4813.76 | 0.00 | 0.00 | 4813.76 | 0.00 |
Wu, Randy, J,11647 | 2365.94 | 0.00 | 0.00 | 2365.94 | 0.00 |
Robinson, Zachary, L,13709 | 2332.28 | 0.00 | 0.00 | 0.00 | 2332.28 |
Gonzales, Melissa, W,20470 | 4408.69 | 0.00 | 2071.42 | 0.00 | 2337.27 |
Mitchell, Alexandra,14455 | 218.93 | 0.00 | 0.00 | 23.97 | 194.96 |
Rubio, Jaime, R,15007 | 209.83 | 0.00 | 0.00 | 49.97 | 159.86 |
Clark, Joseph, D,15395 | 4780.02 | 0.00 | 0.00 | 0.00 | 4780.02 |
Lee, Alexander, S,18356 | 149.91 | 0.00 | 0.00 | 0.00 | 149.91 |
Patterson, Eric, A,27384 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
Russell, Gail, L,21263 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Wilson, Tyler, L,15879 | 196.93 | 0.00 | 0.00 | 69.99 | 126.94 |
Hayes, Arianna,25991 | 2845.52 | 0.00 | 2181.56 | 0.00 | 663.96 |
Flores, Gabriel,27111 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Carter, Katherine,11861 | 286.30 | 0.00 | 0.00 | 0.00 | 286.30 |
Generated 2024-09-20 02:36:16.206 UTC