[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Flores, Arianna,21727 | 4132.24 | 3578.27 | 0.00 | 0.00 | 553.97 |
| James, Sara,19802 | 3374.99 | 3374.99 | 0.00 | 0.00 | 0.00 |
| Green, Isabella,26620 | 699.10 | 699.10 | 0.00 | 0.00 | 0.00 |
| Alexander, Aidan,17387 | 148.19 | 0.00 | 0.00 | 148.19 | 0.00 |
| Ye, Alisha, J,22008 | 4141.23 | 3578.27 | 0.00 | 0.00 | 562.96 |
| Mitchell, Lucas, C,19829 | 4533.45 | 3374.99 | 0.00 | 0.00 | 1158.46 |
| Martin, Lucas, L,22114 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Murphy, Emma,19844 | 5807.93 | 3374.99 | 0.00 | 0.00 | 2432.94 |
| Martin, Xavier,22233 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Diaz, Luis, D,11203 | 801.77 | 0.00 | 0.00 | 317.50 | 484.27 |
| Henderson, Gabrielle, B,18603 | 1205.47 | 0.00 | 0.00 | 1205.47 | 0.00 |
| Lewis, Seth,26782 | 699.10 | 0.00 | 699.10 | 0.00 | 0.00 |
| Chapman, Nancy, E,11276 | 840.15 | 0.00 | 0.00 | 156.71 | 683.44 |
| Collins, Luis, J,22765 | 5978.61 | 0.00 | 3578.27 | 0.00 | 2400.34 |
| Moore, Taylor, A,19987 | 4564.45 | 0.00 | 3374.99 | 0.00 | 1189.46 |
| Turner, Courtney, A,22975 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Perez, Eduardo, M,22895 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Stewart, Katherine, Z,22901 | 5971.33 | 0.00 | 3578.27 | 0.00 | 2393.06 |
| Thomas, Alexandra, C,23172 | 4809.39 | 0.00 | 3578.27 | 1231.12 | 0.00 |
| Green, Gabrielle, M,21815 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Richardson, Caitlin, T,23057 | 6021.82 | 0.00 | 3578.27 | 0.00 | 2443.55 |
| Washington, Caroline, D,23114 | 5996.32 | 0.00 | 3578.27 | 0.00 | 2418.05 |
| Russell, Jacqueline,18391 | 100.96 | 0.00 | 0.00 | 100.96 | 0.00 |
| Bryant, Kyle,23164 | 4807.10 | 0.00 | 3578.27 | 1228.83 | 0.00 |
| Bryant, Isabella, L,22995 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| James, Jeremiah, S,11661 | 287.70 | 0.00 | 0.00 | 104.97 | 182.73 |
| Phillips, Jackson, D,23378 | 5317.23 | 0.00 | 3578.27 | 0.00 | 1738.96 |
| Harris, Megan,23281 | 4828.11 | 0.00 | 3578.27 | 1249.84 | 0.00 |
| Ware, Dennis, L,23725 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Murphy, Catherine, L,16506 | 92.05 | 0.00 | 0.00 | 30.97 | 61.08 |
| Alexander, Ashley, J,20007 | 4495.48 | 0.00 | 3374.99 | 0.00 | 1120.49 |
| Harris, Isabella,17119 | 214.90 | 0.00 | 0.00 | 214.90 | 0.00 |
| Bryant, Connor,23842 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Davis, Daniel,11711 | 999.22 | 0.00 | 0.00 | 100.46 | 898.76 |
| Washington, Vanessa,23819 | 4802.11 | 0.00 | 3578.27 | 0.00 | 1223.84 |
| Thompson, Jose,23731 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Smith, Katherine, J,13197 | 105.19 | 0.00 | 0.00 | 49.97 | 55.22 |
| Diaz, Aidan, L,23846 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Young, Sierra, J,11619 | 634.84 | 0.00 | 0.00 | 187.43 | 447.41 |
| Martinez, Jill,24235 | 4829.39 | 0.00 | 3578.27 | 0.00 | 1251.12 |
| Flores, Xavier,23866 | 4828.11 | 0.00 | 3578.27 | 0.00 | 1249.84 |
| Turner, Timothy, C,14641 | 119.86 | 0.00 | 0.00 | 49.97 | 69.89 |
| Bennett, Seth,24493 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Patterson, Maria, G,13330 | 94.95 | 0.00 | 0.00 | 79.97 | 14.98 |
| Prasad, Molly,24392 | 4329.61 | 0.00 | 3578.27 | 751.34 | 0.00 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 2371.94 | 0.00 |
| Murphy, Juan, T,24646 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Garcia, Victoria, V,24501 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Li, Connor,20186 | 3191.91 | 0.00 | 2071.42 | 0.00 | 1120.49 |
| Sharma, Yolanda, K,25048 | 3046.84 | 0.00 | 2443.35 | 603.49 | 0.00 |
| Walker, John, M,28589 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Perry, Ana,11215 | 1155.52 | 0.00 | 0.00 | 496.36 | 659.16 |
| Turner, Andrea, A,20209 | 3268.55 | 0.00 | 2049.10 | 0.00 | 1219.45 |
| Martin, Morgan,24832 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Sanders, Paige,25287 | 2983.34 | 0.00 | 2443.35 | 0.00 | 539.99 |
| Ross, Haley, T,25361 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Turner, Amanda, L,20318 | 3241.90 | 0.00 | 2071.42 | 0.00 | 1170.48 |
| Zhao, Karen, L,25408 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Garcia, Patricia,11651 | 226.43 | 0.00 | 0.00 | 134.95 | 91.48 |
| Price, Stephanie,25892 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Gomez, Renee, L,25371 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Morgan, Timothy,14633 | 242.50 | 0.00 | 0.00 | 95.55 | 146.95 |
| Price, Jocelyn, D,25875 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Cox, Lucas, J,25393 | 2443.35 | 0.00 | 2443.35 | 0.00 | 0.00 |
| Moore, Matthew, W,13267 | 109.95 | 0.00 | 0.00 | 74.98 | 34.97 |
| Lopez, Carlos,18617 | 1147.77 | 0.00 | 0.00 | 1147.77 | 0.00 |
| Cook, Megan, J,20299 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Anderson, Emma, A,18580 | 1170.48 | 0.00 | 0.00 | 1170.48 | 0.00 |
| Sanchez, Adrian, L,13179 | 190.17 | 0.00 | 0.00 | 77.92 | 112.25 |
| Gonzales, Luis,15856 | 116.25 | 0.00 | 0.00 | 116.25 | 0.00 |
| Wright, Kyle,23716 | 26.97 | 0.00 | 0.00 | 26.97 | 0.00 |
| Coleman, Isabel, S,12530 | 337.90 | 0.00 | 0.00 | 193.95 | 143.95 |
| Sandberg, Isaac,13350 | 53.97 | 0.00 | 0.00 | 39.99 | 13.98 |
| Phillips, James, G,16846 | 180.95 | 0.00 | 0.00 | 180.95 | 0.00 |
| Price, Jeremy,25989 | 2744.52 | 0.00 | 2181.56 | 0.00 | 562.96 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 2049.10 | 0.00 | 1120.49 |
| Miller, Katherine, B,27102 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Campbell, Jordan,13290 | 111.89 | 0.00 | 0.00 | 74.98 | 36.91 |
| Townsend, Jeremiah, I,26503 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Thomas, Isabella, M,27265 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ross, Rachel, C,20669 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Cox, Julia, A,20670 | 3228.57 | 0.00 | 0.00 | 2049.10 | 1179.47 |
| Scott, Kaitlyn, A,12159 | 218.91 | 0.00 | 0.00 | 203.93 | 14.98 |
| Thompson, Joshua, F,25999 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
| Phillips, Jack, R,25995 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Stewart, Andrea, M,27252 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Gomez, Rebekah,13486 | 225.44 | 0.00 | 0.00 | 39.98 | 185.46 |
| Ramirez, Abigail, S,15859 | 74.14 | 0.00 | 0.00 | 24.27 | 49.87 |
| Butler, Ana,26040 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Thompson, Devin,20708 | 4406.40 | 0.00 | 0.00 | 2071.42 | 2334.98 |
| Washington, Taylor,21266 | 4525.07 | 0.00 | 0.00 | 2049.10 | 2475.97 |
| Foster, Deb,21501 | 2661.40 | 0.00 | 0.00 | 2661.40 | 0.00 |
| Sharma, Jackson,16876 | 151.84 | 0.00 | 0.00 | 34.89 | 116.95 |
| Adams, Connor,21423 | 2888.56 | 0.00 | 0.00 | 2049.10 | 839.46 |
| Collins, Connor, J,27270 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Mitchell, Maria, D,27404 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Ramirez, Sydney,26700 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Davis, James,11922 | 275.50 | 0.00 | 0.00 | 94.96 | 180.54 |
| Lal, Luke, L,11019 | 698.23 | 0.00 | 0.00 | 156.20 | 542.03 |
| Williams, Edward, D,14274 | 121.56 | 0.00 | 0.00 | 9.99 | 111.57 |
| Hernandez, Haley, L,11769 | 478.95 | 0.00 | 0.00 | 78.98 | 399.97 |
| Scott, Haley,13701 | 154.54 | 0.00 | 0.00 | 36.59 | 117.95 |
| Edwards, Connor,16950 | 211.01 | 0.00 | 0.00 | 23.97 | 187.04 |
| Johnson, Anthony, D,27022 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Li, Kevin, S,25188 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Peterson, Jessica, M,11868 | 247.01 | 0.00 | 0.00 | 76.95 | 170.06 |
| Lee, Ethan, J,22359 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Martinez, Jonathan,13303 | 66.25 | 0.00 | 0.00 | 42.28 | 23.97 |
| Hall, Lauren, A,19648 | 100.84 | 0.00 | 0.00 | 36.59 | 64.25 |
| Moore, Andrew, A,13944 | 150.13 | 0.00 | 0.00 | 107.85 | 42.28 |
| Lewis, Brandon, A,29037 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Diaz, Alyssa,13908 | 4715.33 | 0.00 | 0.00 | 2294.99 | 2420.34 |
| Griffin, Jack, L,17686 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Adams, Miguel,11659 | 213.52 | 0.00 | 0.00 | 64.97 | 148.55 |
| Liu, Arturo,13222 | 150.41 | 0.00 | 0.00 | 88.44 | 61.97 |
| Shan, Logan,18677 | 60.96 | 0.00 | 0.00 | 60.96 | 0.00 |
| Griffin, Thomas, J,19015 | 125.43 | 0.00 | 0.00 | 125.43 | 0.00 |
| Bell, Julia,21652 | 2646.06 | 0.00 | 0.00 | 2646.06 | 0.00 |
| Johnson, Andrew, F,26294 | 2443.35 | 0.00 | 0.00 | 2443.35 | 0.00 |
| Rodriguez, Alexandra,21642 | 2620.40 | 0.00 | 0.00 | 2071.42 | 548.98 |
| Thomas, William, A,21614 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Moore, Fernando,26582 | 1000.44 | 0.00 | 0.00 | 1000.44 | 0.00 |
| Patterson, Grace, M,27560 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Sanchez, Trinity, J,26279 | 2181.56 | 0.00 | 0.00 | 2181.56 | 0.00 |
Generated 2024-09-20 01:08:30.777 UTC