[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 76 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Washington, Kelly, M,28748 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Simmons, Faith, S,15614 | 6059.18 | 0.00 | 3578.27 | 0.00 | 2480.91 |
| Deng, Edwin, A,17085 | 2986.03 | 0.00 | 0.00 | 2181.56 | 804.47 |
| Rowe, Alberto, W,26973 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Tang, Kenneth,28477 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Gonzalez, Cassandra,17967 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Collins, Blake,11610 | 6786.44 | 0.00 | 2071.42 | 0.00 | 4715.02 |
| Wood, Julian, A,18166 | 7200.37 | 0.00 | 0.00 | 2443.35 | 4757.02 |
| Shan, Tommy, H,22614 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Ye, Rosa, C,19940 | 3440.43 | 0.00 | 0.00 | 1000.44 | 2439.99 |
| Diaz, Blake, E,18135 | 6921.58 | 0.00 | 0.00 | 2181.56 | 4740.02 |
| Thompson, Emma, C,19445 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Nelson, Haley,27185 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| He, Claudia, F,24093 | 2466.32 | 0.00 | 0.00 | 2466.32 | 0.00 |
| Martin, Sheila,15635 | 116.95 | 0.00 | 0.00 | 0.00 | 116.95 |
| Rodriguez, Manuel, A,24697 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Torres, Ian, V,17207 | 6979.56 | 0.00 | 0.00 | 2181.56 | 4798.00 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Li, Jorge, V,20133 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Zhu, Lisa, R,15059 | 6793.54 | 0.00 | 3578.27 | 0.00 | 3215.27 |
| Sun, Trisha,22442 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Huang, Clarence, C,19341 | 3498.78 | 0.00 | 0.00 | 3498.78 | 0.00 |
| Luo, Alisha,24534 | 2533.93 | 0.00 | 0.00 | 0.00 | 2533.93 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Martin, Joseph,11388 | 6986.75 | 0.00 | 3374.99 | 2342.92 | 1268.84 |
| Henderson, Alexandria, R,11555 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sharma, Willie, W,22427 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Andersen, Katrina,19032 | 6938.58 | 0.00 | 0.00 | 2181.56 | 4757.02 |
| Young, Gabriella, M,19305 | 1622.40 | 0.00 | 0.00 | 1000.44 | 621.96 |
| Sharma, Wayne, E,19175 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Martin, Jerome, D,20170 | 3177.44 | 0.00 | 699.10 | 0.00 | 2478.34 |
| Perez, Regina, S,19031 | 7226.38 | 0.00 | 0.00 | 2443.35 | 4783.03 |
| Williams, Emma, K,16325 | 171.27 | 0.00 | 0.00 | 0.00 | 171.27 |
| Washington, Destiny,22812 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Deng, Brendan,25726 | 663.44 | 0.00 | 0.00 | 0.00 | 663.44 |
| Carlson, Lee, S,21079 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Long, Miguel,24853 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jones, Andrew, C,16594 | 7231.37 | 0.00 | 0.00 | 2443.35 | 4788.02 |
| Thomas, Jose, A,26960 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Raman, Nancy, M,20588 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Jones, David, D,20866 | 3157.97 | 0.00 | 0.00 | 782.99 | 2374.98 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Liang, Krystal, S,12404 | 5251.71 | 0.00 | 0.00 | 2071.42 | 3180.29 |
| Walker, Sarah, R,13814 | 230.04 | 0.00 | 0.00 | 0.00 | 230.04 |
| Foster, Mary,24112 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Morgan, Angel, G,24835 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Rogers, Christina, F,21668 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Cox, Isaiah, E,13584 | 8361.29 | 3578.27 | 0.00 | 0.00 | 4783.02 |
| Williams, Blake,29421 | 78.48 | 0.00 | 0.00 | 0.00 | 78.48 |
| Morgan, Kimberly, A,28735 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Ortega, Stacy, M,25669 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Jai, Grant,24200 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Diaz, Erik, S,11565 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Sanchez, Edgar,11604 | 6786.12 | 0.00 | 2049.10 | 0.00 | 4737.02 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Alonso, Jaime,15062 | 6684.59 | 0.00 | 3578.27 | 0.00 | 3106.32 |
| Chander, Nichole, H,28451 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
Generated 2025-12-23 11:16:06.643 UTC