[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 9 > < TAKE 48 >
48 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Johnny,19330 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Pearson, Simon,13472 | 2518.98 | 0.00 | 0.00 | 0.00 | 2518.98 |
| Nath, Brendan, C,22380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Srini, Pamela,15892 | 1401.46 | 0.00 | 0.00 | 782.99 | 618.47 |
| Scott, Natalie, K,18764 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ross, James, F,14270 | 1794.20 | 0.00 | 0.00 | 1000.44 | 793.76 |
| Ye, Jessie, J,14145 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Lee, Benjamin,16975 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Xu, Franklin, D,17103 | 6935.08 | 0.00 | 0.00 | 2181.56 | 4753.52 |
| Hayes, Antonio,26596 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Parker, Jack,17270 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Ward, Paige,16953 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Ye, Suzanne,27173 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Goel, Melvin, A,25442 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Sanchez, Donald,22598 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Lopez, Hailey, M,15470 | 76.96 | 0.00 | 0.00 | 0.00 | 76.96 |
| Gao, Suzanne,21486 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Hernandez, Amanda,18837 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Walker, Miguel,26636 | 36.27 | 0.00 | 0.00 | 0.00 | 36.27 |
| Cooper, Cole, C,19707 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Coleman, Gavin,24527 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Li, Todd,11233 | 179.43 | 0.00 | 0.00 | 0.00 | 179.43 |
| Foster, Emily,19779 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Edwards, Wyatt,19728 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Thomas, Alyssa, L,20894 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Bennett, Cassidy, A,16951 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Arun, Ebony,21066 | 131.44 | 0.00 | 0.00 | 0.00 | 131.44 |
| Luo, Mitchell, E,28895 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramos, Jimmy,16843 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Richardson, Mariah,12410 | 159.99 | 0.00 | 0.00 | 0.00 | 159.99 |
| Gutierrez, Ebony, R,25975 | 5807.03 | 0.00 | 3399.99 | 0.00 | 2407.04 |
| Hill, Edward, A,19717 | 1137.43 | 0.00 | 0.00 | 0.00 | 1137.43 |
| Dominguez, Mallory,25549 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Goel, Shaun, L,22417 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Torres, Andy, R,24102 | 1779.47 | 0.00 | 0.00 | 1779.47 | 0.00 |
| Moreno, Billy,11572 | 4450.37 | 0.00 | 0.00 | 2071.42 | 2378.95 |
| Kumar, Brandon, A,12790 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Suarez, Latasha,11471 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Patel, Lydia, B,29414 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Gutierrez, Alfredo, J,24724 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Collins, Jackson,29200 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Prasad, Heidi, M,16197 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Edwards, James, K,27508 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Blue, Rachel,17162 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Morris, Nicole, R,24782 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Rivera, Jesse,16249 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lin, Martha,20678 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Reed, Kimberly, D,17311 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
Generated 2025-12-23 06:00:02.808 UTC