[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1500 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhao, Rafael,13412 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Rubio, Rebekah,24699 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Ma, Stacey,21840 | 31.27 | 0.00 | 0.00 | 31.27 | 0.00 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Luo, Alvin,23635 | 2452.34 | 0.00 | 0.00 | 2452.34 | 0.00 |
| Ma, Randy, R,24550 | 37.27 | 0.00 | 0.00 | 37.27 | 0.00 |
| Martinez, Carla,24852 | 2457.33 | 0.00 | 0.00 | 0.00 | 2457.33 |
| Carlson, Diane, W,21074 | 43.97 | 0.00 | 0.00 | 0.00 | 43.97 |
| Yang, Jessie, E,20053 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Ruiz, Ruben, A,20055 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Gill, Briana, D,12654 | 45.26 | 0.00 | 0.00 | 0.00 | 45.26 |
| Ms., Sims, Anne, R.,26869 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Carlson, Darren, D,29478 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Romero, Jaime, B,28508 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Schmidt, Derrick, R,22605 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Sanchez, Preston, J,12506 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Young, Evan,12739 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| 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 |
| Jai, Shawn, E,25501 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Alvarez, Mallory, L,21124 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Williams, Jennifer, E,19457 | 92.48 | 0.00 | 0.00 | 0.00 | 92.48 |
| He, Arturo,29369 | 2422.54 | 0.00 | 0.00 | 0.00 | 2422.54 |
| Ye, Micah, A,20952 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Townsend, Michelle, P,12864 | 86.24 | 0.00 | 0.00 | 0.00 | 86.24 |
| Chande, Tamara, L,28693 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Garcia, Marie,27953 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Deng, Leonard,27821 | 2428.05 | 0.00 | 0.00 | 0.00 | 2428.05 |
| Suri, Henry,21683 | 1779.47 | 0.00 | 0.00 | 0.00 | 1779.47 |
| Wu, Crystal, W,22672 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Romero, Linda, K,20725 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
Generated 2025-12-24 06:47:45.400 UTC