[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 750 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Diaz, Larry, T,13664 | 210.25 | 0.00 | 0.00 | 0.00 | 210.25 |
| Chander, Lindsey,26949 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Perez, Andre,11491 | 8158.01 | 0.00 | 3374.99 | 2329.98 | 2453.04 |
| Tang, Jaclyn, K,21060 | 2508.47 | 0.00 | 0.00 | 782.99 | 1725.48 |
| Rivera, Seth,17879 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Chandra, Donald,11485 | 7048.30 | 0.00 | 3399.99 | 2398.47 | 1249.84 |
| Anand, Nicolas, P,20567 | 3074.08 | 0.00 | 699.10 | 0.00 | 2374.98 |
| Gutierrez, Teresa, A,15083 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
| Gomez, Larry, S,25778 | 2443.35 | 0.00 | 0.00 | 0.00 | 2443.35 |
| Guo, Kelvin, H,17705 | 37.26 | 0.00 | 0.00 | 29.98 | 7.28 |
| Cai, Stacey,20575 | 3095.04 | 0.00 | 699.10 | 0.00 | 2395.94 |
| Dominguez, Felicia, R,14196 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Ruiz, Marc, D,12545 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Chen, Jessie,24069 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Russell, Carson,21116 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Liu, Stacey, A,13557 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
| Campbell, Jackson,11575 | 6806.12 | 0.00 | 2049.10 | 2294.99 | 2462.03 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Martinez, George, L,20570 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Stewart, Natalie, F,17710 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Rodriguez, Noah, J,22325 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Hayes, Marcus, A,15657 | 5251.34 | 0.00 | 3578.27 | 0.00 | 1673.07 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Suri, Michele,18007 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Navarro, Lee,25659 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Suurs, Paul, J,15669 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Jones, Brianna,25546 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Cai, Jamie, S,13505 | 127.93 | 0.00 | 0.00 | 0.00 | 127.93 |
| Subram, Meagan, W,11573 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Liang, Marshall, J,25447 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| She, Trisha, A,18021 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Raje, Brendan,16250 | 4511.54 | 0.00 | 2181.56 | 0.00 | 2329.98 |
| Gonzales, Jessica, A,15610 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Morris, Emma, L,17820 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Diaz, Deanna, D,17720 | 2790.53 | 0.00 | 0.00 | 2181.56 | 608.97 |
| Alvarez, Micheal, W,13495 | 57.95 | 0.00 | 0.00 | 0.00 | 57.95 |
| Xu, Ronnie,17892 | 2787.51 | 0.00 | 0.00 | 2181.56 | 605.95 |
| Yuan, Kristin, C,24114 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Raje, Melvin,11580 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Baker, Seth,21520 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Perez, Fernando,27848 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Ray, Chelsea, R,20717 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Foster, Alexia,11568 | 6789.46 | 0.00 | 2071.42 | 2319.99 | 2398.05 |
| Robinson, Matthew, D,29376 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Raji, Karla, V,15929 | 6944.58 | 0.00 | 2181.56 | 0.00 | 4763.02 |
| Patterson, Margaret, J,13507 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Romero, Alberto,11586 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Carlson, Derrick, R,28436 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Smith, Tabitha,14787 | 163.45 | 0.00 | 0.00 | 0.00 | 163.45 |
| Chande, Priscilla,29358 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Hu, Tiffany, A,20856 | 2483.98 | 0.00 | 0.00 | 782.99 | 1700.99 |
| Shen, Julie,22505 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Zhou, Martha, M,14804 | 138.96 | 0.00 | 0.00 | 0.00 | 138.96 |
| Ward, Caitlin,16445 | 3242.83 | 0.00 | 2443.35 | 0.00 | 799.48 |
| Fernandez, Ruben,19927 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Huang, Alvin,12491 | 86.58 | 0.00 | 0.00 | 0.00 | 86.58 |
| Sanchez, Brenda,25656 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Carlson, Erika,16444 | 3271.82 | 0.00 | 0.00 | 3271.82 | 0.00 |
| Raje, Andres,20710 | 3240.32 | 0.00 | 782.99 | 0.00 | 2457.33 |
| Fernandez, Chelsea, J,19905 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ye, Jamie, C,16329 | 3272.09 | 0.00 | 2443.35 | 0.00 | 828.74 |
| Becker, Kate,16447 | 3001.02 | 0.00 | 0.00 | 2181.56 | 819.46 |
| McDonald, Deborah, R,16275 | 3282.83 | 0.00 | 2443.35 | 0.00 | 839.48 |
| Navarro, Erika, K,11476 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Romero, Melinda,12260 | 241.76 | 0.00 | 0.00 | 182.78 | 58.98 |
| Sun, Vincent, F,16585 | 7192.39 | 0.00 | 0.00 | 2443.35 | 4749.04 |
| Schmidt, Theresa,21854 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Subram, Jermaine,28731 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Rai, Maurice, S,16328 | 3001.04 | 0.00 | 2181.56 | 0.00 | 819.48 |
| Jones, Chloe,20838 | 2541.94 | 0.00 | 0.00 | 2541.94 | 0.00 |
| Sharma, Latoya,19260 | 1592.71 | 0.00 | 1000.44 | 0.00 | 592.27 |
| Young, Gabriella, M,19305 | 1622.40 | 0.00 | 0.00 | 1000.44 | 621.96 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 2443.35 | 819.48 | 0.00 |
| Rodriguez, Bryant, R,29360 | 2418.05 | 0.00 | 0.00 | 0.00 | 2418.05 |
| Huang, Colin,20712 | 3261.33 | 0.00 | 782.99 | 0.00 | 2478.34 |
| Gao, Lacey, C,16531 | 3291.80 | 0.00 | 0.00 | 2443.35 | 848.45 |
| Gill, Marvin, M,17821 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Kumar, Carly, R,24712 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Shan, Cedric, H,23775 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Moreno, Kellie, T,16318 | 3021.02 | 0.00 | 2181.56 | 0.00 | 839.46 |
| Shan, Calvin,20811 | 3270.32 | 0.00 | 782.99 | 0.00 | 2487.33 |
| Tang, Kelvin,20832 | 2533.97 | 0.00 | 782.99 | 1750.98 | 0.00 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alonso, Kendra, C,16427 | 2975.02 | 0.00 | 2181.56 | 793.46 | 0.00 |
| Browning, Carrie, G,19299 | 1587.41 | 0.00 | 1000.44 | 0.00 | 586.97 |
| Xu, Omar, A,22596 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Ramos, Alberto,12239 | 6901.42 | 0.00 | 0.00 | 2071.42 | 4830.00 |
| McDonald, Gilbert, G,17226 | 109.97 | 0.00 | 0.00 | 0.00 | 109.97 |
| Raji, Raul, P,21135 | 103.95 | 0.00 | 0.00 | 0.00 | 103.95 |
| Sai, Veronica,16509 | 3258.79 | 0.00 | 0.00 | 2443.35 | 815.44 |
| Sharma, Ricardo,16512 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Ramos, Ruben, L,23762 | 1164.47 | 0.00 | 0.00 | 0.00 | 1164.47 |
| Jordan, Terrance, B,16546 | 3036.53 | 0.00 | 0.00 | 2181.56 | 854.97 |
| Gonzalez, Tammy, J,25657 | 609.45 | 0.00 | 0.00 | 0.00 | 609.45 |
| Navarro, Lance, C,20850 | 2556.94 | 0.00 | 0.00 | 2556.94 | 0.00 |
| Liu, Vincent,20848 | 2558.46 | 0.00 | 0.00 | 2558.46 | 0.00 |
| Jai, Damien,14806 | 242.94 | 0.00 | 0.00 | 0.00 | 242.94 |
| Roberts, Gabriella, J,16553 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Hu, Micah, A,16541 | 3028.02 | 0.00 | 0.00 | 2181.56 | 846.46 |
| Chander, Casey, C,16554 | 2990.52 | 0.00 | 0.00 | 2181.56 | 808.96 |
| Romero, Roy, C,20859 | 2508.97 | 0.00 | 0.00 | 782.99 | 1725.98 |
| Zheng, Valerie, R,19312 | 1564.70 | 0.00 | 0.00 | 1000.44 | 564.26 |
| Henderson, Marissa,13816 | 260.83 | 0.00 | 0.00 | 0.00 | 260.83 |
| Edwards, Julia, M,16200 | 96.95 | 0.00 | 0.00 | 0.00 | 96.95 |
| Rai, Kate,16598 | 7131.40 | 0.00 | 0.00 | 2443.35 | 4688.05 |
| Howard, Grace, J,20864 | 3234.29 | 0.00 | 0.00 | 782.99 | 2451.30 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Sara, Arthur, D,23753 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Rubio, Victor, S,16193 | 90.47 | 0.00 | 0.00 | 4.99 | 85.48 |
| Zhao, Stacey, J,28365 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Wang, Tamara, L,17881 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Kapoor, Heidi, D,17937 | 3068.82 | 0.00 | 0.00 | 2443.35 | 625.47 |
| Martin, Gloria, A,12325 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Zhang, Margaret, G,16058 | 38.25 | 0.00 | 0.00 | 0.00 | 38.25 |
| Chen, Valerie,19911 | 3335.41 | 0.00 | 0.00 | 1000.44 | 2334.97 |
| Moreno, Gary, E,21544 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Kapoor, Deanna, D,17097 | 3021.02 | 0.00 | 0.00 | 2181.56 | 839.46 |
| Moreno, Albert,12402 | 5218.40 | 0.00 | 0.00 | 2049.10 | 3169.30 |
| Raje, Karl,19362 | 3443.79 | 0.00 | 0.00 | 3443.79 | 0.00 |
| Sanchez, Pamela,20879 | 3284.30 | 0.00 | 0.00 | 782.99 | 2501.31 |
Generated 2024-11-10 09:48:06.797 UTC