[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 250 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Blanco, Jessie, R,23608 | 2510.94 | 0.00 | 0.00 | 2510.94 | 0.00 |
| Kelly, Alexa,15075 | 74.98 | 0.00 | 0.00 | 69.99 | 4.99 |
| Torres, Adrienne, C,11482 | 8143.03 | 0.00 | 3374.99 | 2354.98 | 2413.06 |
| Xu, Terrence, L,23743 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 782.99 | 1775.47 | 0.00 |
| Arun, Meagan, W,23930 | 1243.44 | 0.00 | 0.00 | 0.00 | 1243.44 |
| Raman, Lydia,26868 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nara, Drew, A,26944 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Ashe, Tasha, W,24881 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Holly,26876 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Torres, Shannon,12612 | 5657.91 | 0.00 | 0.00 | 2049.10 | 3608.81 |
| Lin, Rosa,12856 | 4460.38 | 0.00 | 0.00 | 2071.42 | 2388.96 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Barbara,24019 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Garcia, Douglas,24860 | 2520.31 | 0.00 | 0.00 | 0.00 | 2520.31 |
| Hughes, Amanda,16189 | 105.94 | 0.00 | 0.00 | 0.00 | 105.94 |
| Sanz, Naomi,12840 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Castro, Jacquelyn,21093 | 2515.25 | 0.00 | 0.00 | 2515.25 | 0.00 |
| Thompson, Morgan, Q,24011 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Schmidt, Marc,12808 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Yuan, Omar, C,12380 | 5570.22 | 0.00 | 0.00 | 2049.10 | 3521.12 |
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 2533.93 | 0.00 |
| Deng, Kelli,22794 | 27.28 | 0.00 | 0.00 | 27.28 | 0.00 |
| Dominguez, Teresa, C,20963 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Wu, Ramon, M,27955 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Raman, Holly,25477 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Perez, Dominic, A,23940 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Lal, Tamara,13576 | 8330.79 | 3578.27 | 0.00 | 0.00 | 4752.52 |
| Martin, Derrick,14191 | 8301.31 | 3578.27 | 0.00 | 0.00 | 4723.04 |
| Anand, Peter,14929 | 6646.58 | 0.00 | 3578.27 | 0.00 | 3068.31 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| James, Jade, M,26400 | 132.98 | 0.00 | 0.00 | 132.98 | 0.00 |
| Carlson, Felicia,19502 | 3565.36 | 0.00 | 0.00 | 3565.36 | 0.00 |
| Yuan, Kelvin, L,25692 | 66.97 | 0.00 | 0.00 | 66.97 | 0.00 |
| Tang, Alvin, L,21678 | 42.93 | 0.00 | 0.00 | 42.93 | 0.00 |
| Gao, Autumn, W,24085 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Wu, Colleen,19291 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| Xu, Gilbert,22554 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Lin, Brent, L,27788 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Martinez, Bryant,19471 | 3478.78 | 0.00 | 0.00 | 3478.78 | 0.00 |
| Baker, Katherine,19334 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Zhang, Colleen, L,16562 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Alonso, Tanya, K,26942 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Long, Maria,16036 | 61.96 | 0.00 | 0.00 | 21.98 | 39.98 |
| Wagner, Deb, R,24030 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Carlson, Darren, D,29478 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Kovar, Kristina, R,26910 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Gomez, Kristine, E,18627 | 3027.32 | 0.00 | 0.00 | 2443.35 | 583.97 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Henderson, Anna,24857 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Audrey, S,26937 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Rai, Cassie, R,14194 | 168.93 | 0.00 | 0.00 | 68.97 | 99.96 |
| Tang, Nicolas, S,12282 | 5111.44 | 0.00 | 2049.10 | 3062.34 | 0.00 |
| Li, Susan,27839 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Wang, Franklin, S,29386 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Russell, Christian, S,22826 | 34.98 | 0.00 | 0.00 | 34.98 | 0.00 |
| Nath, Nichole, K,12392 | 75.47 | 0.00 | 0.00 | 75.47 | 0.00 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 6825.46 | 0.00 |
| Gonzalez, Evelyn, L,12859 | 5666.22 | 0.00 | 0.00 | 2071.42 | 3594.80 |
| Zheng, Leah, R,12627 | 110.94 | 0.00 | 0.00 | 8.99 | 101.95 |
| Martin, Orlando, C,16300 | 111.95 | 0.00 | 0.00 | 0.00 | 111.95 |
| Sara, Manuel,12611 | 67.46 | 0.00 | 0.00 | 0.00 | 67.46 |
| Kumar, Peter,26915 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 2294.99 | 2462.03 |
| Hernandez, Francis,21103 | 2506.95 | 0.00 | 0.00 | 2506.95 | 0.00 |
| Alvarez, Lance, J,16190 | 79.25 | 0.00 | 0.00 | 7.28 | 71.97 |
| Goel, Johnny, J,22569 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Gutierrez, Shannon, L,17101 | 163.94 | 0.00 | 0.00 | 94.97 | 68.97 |
| Ortega, Leslie,24851 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Davis, Zachary, L,16579 | 97.95 | 0.00 | 0.00 | 0.00 | 97.95 |
| Alonso, Latasha, A,13591 | 8355.27 | 3578.27 | 0.00 | 0.00 | 4777.00 |
| Yuan, Arturo,20968 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Alvarez, Erika,15615 | 70.24 | 0.00 | 0.00 | 42.28 | 27.96 |
| Kapoor, George, L,13676 | 68.87 | 0.00 | 0.00 | 36.27 | 32.60 |
| Foster, Mya, M,23230 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Garcia, Abigail,14531 | 190.54 | 0.00 | 0.00 | 190.54 | 0.00 |
| Kapoor, Jillian, R,15701 | 78.86 | 0.00 | 0.00 | 7.28 | 71.58 |
| Goel, Calvin, J,17213 | 179.95 | 0.00 | 0.00 | 0.00 | 179.95 |
| Suri, Tabitha,27957 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Raji, Tara,12385 | 5118.75 | 0.00 | 0.00 | 5118.75 | 0.00 |
| Hernandez, Larry,17840 | 228.96 | 0.00 | 0.00 | 188.98 | 39.98 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 3583.81 | 0.00 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Bradley, Isabel,27783 | 165.28 | 0.00 | 0.00 | 165.28 | 0.00 |
| Gill, Clinton,26210 | 553.97 | 0.00 | 0.00 | 553.97 | 0.00 |
| Ruiz, Audrey,12645 | 6847.76 | 0.00 | 0.00 | 6847.76 | 0.00 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 2049.10 | 3120.26 | 0.00 |
| Raji, Mario,28695 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rubio, Teresa, R,27121 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Lopez, Andre,11434 | 70.46 | 0.00 | 0.00 | 0.00 | 70.46 |
| Morgan, Sean,14993 | 152.94 | 0.00 | 0.00 | 74.98 | 77.96 |
| Raji, Nina, W,29480 | 2442.03 | 0.00 | 0.00 | 0.00 | 2442.03 |
| Mr., Shimshoni, Daniel,24705 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Martin, Mallory, J,13794 | 7212.06 | 3578.27 | 0.00 | 0.00 | 3633.79 |
| Nara, Omar, J,13535 | 59.20 | 0.00 | 0.00 | 0.00 | 59.20 |
| Sanchez, Emmanuel, F,21856 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Black, Willie,18172 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Chen, Gilbert, E,27906 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Nath, Clayton,14793 | 5948.24 | 0.00 | 3578.27 | 0.00 | 2369.97 |
| Munoz, Stacy,12310 | 103.96 | 0.00 | 0.00 | 0.00 | 103.96 |
| Xu, Eugene, A,14208 | 117.43 | 0.00 | 0.00 | 58.47 | 58.96 |
| Rai, Cedric,22838 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Nath, Lindsay,21841 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Romero, Jerome,11337 | 8162.00 | 3374.99 | 0.00 | 2388.96 | 2398.05 |
| Vazquez, Meghan, W,15047 | 6669.57 | 0.00 | 3578.27 | 0.00 | 3091.30 |
| Lal, Kelli, J,19173 | 1594.42 | 0.00 | 1000.44 | 0.00 | 593.98 |
| Sutton, Marshall,20862 | 3240.32 | 0.00 | 0.00 | 782.99 | 2457.33 |
| Vance, Regina, M,14984 | 6699.57 | 0.00 | 3578.27 | 0.00 | 3121.30 |
| Kumar, Arturo, W,24044 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Vazquez, Jaime,22304 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Ray, Harold, A,13516 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Jimenez, Jessie,11344 | 8119.81 | 0.00 | 3399.99 | 2297.28 | 2422.54 |
| Andersen, Brad, S,26992 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Taylor, Blake, S,17889 | 3043.33 | 0.00 | 0.00 | 2443.35 | 599.98 |
| Deng, Sharon, A,26893 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Carlson, Arthur, P,11343 | 8221.99 | 3399.99 | 0.00 | 2379.97 | 2442.03 |
| Tang, Tonya,20917 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| Jenkins, Kayla, A,14777 | 5923.23 | 0.00 | 3578.27 | 0.00 | 2344.96 |
| Raman, Darren, K,22315 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sanz, Pedro,18168 | 6907.55 | 0.00 | 0.00 | 2181.56 | 4725.99 |
| Taylor, Michael,27907 | 578.46 | 0.00 | 0.00 | 0.00 | 578.46 |
| Romero, Darren, A,19195 | 1637.38 | 0.00 | 1000.44 | 0.00 | 636.94 |
Generated 2024-09-20 09:39:49.006 UTC