[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 75 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Martin, Janet, L,24540 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
| Alonso, Micheal, W,19307 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Sanchez, Janelle,12281 | 5169.36 | 0.00 | 0.00 | 2826.44 | 2342.92 |
| Raje, Kenneth,23606 | 2543.44 | 0.00 | 0.00 | 2543.44 | 0.00 |
| James, Gabriella, S,22594 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Hughes, Kayla,14982 | 152.45 | 0.00 | 0.00 | 0.00 | 152.45 |
| Deng, Carly, E,22452 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Washington, Faith,20849 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Blanco, Rebekah,18149 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Randall, Tammy, C,13798 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Kelly, Jacqueline,21034 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Gutierrez, Walter,25141 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Black, Nichole,22422 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Jimenez, Janet, P,17112 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Mr., Saravan, K.,14974 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Sara, Cory, A,21105 | 2533.97 | 0.00 | 0.00 | 782.99 | 1750.98 |
| Torres, Teresa, M,16188 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thompson, Nathan, T,25523 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Luo, Gregory,17642 | 32.95 | 0.00 | 0.00 | 0.00 | 32.95 |
| Navarro, Hector,23907 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Madan, Carolyn,26222 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Rubio, Jimmy,20837 | 2547.95 | 0.00 | 0.00 | 2547.95 | 0.00 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| McDonald, Harold, J,15051 | 6650.60 | 0.00 | 3578.27 | 0.00 | 3072.33 |
| Ramos, Julio,12551 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Gao, Kelli,20172 | 3150.40 | 0.00 | 699.10 | 0.00 | 2451.30 |
| Navarro, Randall, A,18620 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Sanchez, Brett,12608 | 5689.88 | 0.00 | 0.00 | 2049.10 | 3640.78 |
| Zeng, Darryl, C,20929 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Lal, Lindsay, H,20557 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Garcia, Carla,14172 | 75.74 | 0.00 | 0.00 | 0.00 | 75.74 |
| Garcia, Bob,19186 | 1562.41 | 0.00 | 1000.44 | 0.00 | 561.97 |
| Jenkins, Connor,20800 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Jai, Lindsey, W,23971 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gomez, Bruce,15695 | 8324.24 | 0.00 | 3578.27 | 0.00 | 4745.97 |
| Mehta, Ivan, S,26390 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Alonso, Arthur, M,19054 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Serrano, Joe, M,20167 | 3142.45 | 0.00 | 699.10 | 0.00 | 2443.35 |
| Sanz, Mallory,14938 | 107.97 | 0.00 | 0.00 | 0.00 | 107.97 |
| Garcia, Tabitha,27778 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Yuan, Cedric,15449 | 49.56 | 0.00 | 0.00 | 0.00 | 49.56 |
| Rodriguez, Barry, O,12554 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Cai, Jenny, W,29387 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Black, Raul,25301 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Gill, Clinton,26210 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Beck, Clayton,11579 | 43.98 | 0.00 | 0.00 | 0.00 | 43.98 |
| Chapman, Bob, W,21134 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Goel, Shawn, L,19058 | 4524.48 | 0.00 | 0.00 | 2181.56 | 2342.92 |
| Guo, Roger,13539 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Chen, Heather, M,29408 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Navarro, Wendy, C,20881 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Thomas, Ryan,22532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Jackson, Lucas, A,25481 | 2478.34 | 0.00 | 0.00 | 0.00 | 2478.34 |
| Carlson, Micheal, E,27164 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Anand, Dustin,14535 | 123.47 | 0.00 | 0.00 | 0.00 | 123.47 |
Generated 2025-12-23 12:04:09.208 UTC