[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 937 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Prasad, Cassandra, D,18621 | 3033.33 | 0.00 | 0.00 | 2443.35 | 589.98 |
| Lu, Dawn, G,27833 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Sara, Toni, E,14146 | 6750.56 | 0.00 | 3578.27 | 827.33 | 2344.96 |
| Jenkins, Adam, M,18633 | 2793.50 | 0.00 | 0.00 | 2181.56 | 611.94 |
| Howard, Jennifer,16264 | 61.96 | 0.00 | 0.00 | 0.00 | 61.96 |
| Romero, Diana,17760 | 92.25 | 0.00 | 0.00 | 0.00 | 92.25 |
| Navarro, Randall, A,18620 | 3001.04 | 0.00 | 0.00 | 2181.56 | 819.48 |
| Alvarez, Roberto,28387 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Sanchez, Raymond,11548 | 7068.27 | 0.00 | 3374.99 | 0.00 | 3693.28 |
| Navarro, Gary, E,13561 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| He, Franklin, K,18127 | 6982.07 | 0.00 | 0.00 | 2181.56 | 4800.51 |
| Raje, Omar, R,12309 | 102.26 | 0.00 | 0.00 | 0.00 | 102.26 |
| Rogers, Christina, F,21668 | 2518.97 | 0.00 | 0.00 | 782.99 | 1735.98 |
| Moreno, Jamie,22526 | 1732.26 | 0.00 | 0.00 | 0.00 | 1732.26 |
| Liang, Sandra, J,20949 | 154.98 | 0.00 | 0.00 | 0.00 | 154.98 |
| Rana, Allen, D,19036 | 4763.34 | 0.00 | 0.00 | 2443.35 | 2319.99 |
| Carlson, Tyrone, S,22662 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Carl,12743 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Jiménez, Javier, M,22687 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Patel, Rebekah, R,22396 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Martinez, Francisco,11375 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Gao, Colleen,15108 | 210.54 | 0.00 | 0.00 | 0.00 | 210.54 |
| Chande, Lacey, A,24555 | 58.95 | 0.00 | 0.00 | 0.00 | 58.95 |
| Samant, Mandar,12873 | 5676.24 | 0.00 | 0.00 | 2071.42 | 3604.82 |
| Carlson, Natasha,21136 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Zeng, Alan, M,22321 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Gomez, Gerald,17743 | 2793.52 | 0.00 | 0.00 | 2181.56 | 611.96 |
| Ruiz, Jaime, J,25609 | 565.47 | 0.00 | 0.00 | 565.47 | 0.00 |
| Fernandez, Deanna,24554 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Wang, Dawn, L,27152 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Gonzalez, Raymond, P,28755 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Zhou, Leah, L,22309 | 1785.97 | 0.00 | 0.00 | 0.00 | 1785.97 |
| Chande, Kelsey, K,14846 | 6744.57 | 0.00 | 3578.27 | 0.00 | 3166.30 |
| Ashe, Tasha, W,24881 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shan, Terrence,20907 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Srini, Stanley,18042 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Jimenez, Roy,12334 | 44.22 | 0.00 | 0.00 | 0.00 | 44.22 |
| Simmons, Kevin,12630 | 6825.46 | 0.00 | 0.00 | 2071.42 | 4754.04 |
| Ramirez, Megan, C,11387 | 6958.80 | 0.00 | 3374.99 | 2354.98 | 1228.83 |
| Prasad, Pedro, D,19077 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Harrison, Bianca, J,17886 | 38.97 | 0.00 | 0.00 | 0.00 | 38.97 |
| Anand, Colleen, N,12647 | 6886.60 | 0.00 | 0.00 | 2049.10 | 4837.50 |
| Sanz, Latasha,29384 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Richardson, Angel,12640 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Bradley, Isabel,27783 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Chandra, Roy, R,24583 | 2487.33 | 0.00 | 0.00 | 0.00 | 2487.33 |
| Rai, Priscilla, C,12619 | 5200.41 | 0.00 | 0.00 | 2049.10 | 3151.31 |
| Wu, Jenny, S,23944 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Saunders, Dominique, M,29469 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Zhou, Valerie, J,17828 | 3262.83 | 0.00 | 0.00 | 2443.35 | 819.48 |
| Miller, Emily, R,11333 | 8163.31 | 0.00 | 3399.99 | 2344.26 | 2419.06 |
| Rai, Kelvin, M,26833 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Perez, Jack,19455 | 3478.78 | 0.00 | 0.00 | 1000.44 | 2478.34 |
| Sara, Bruce,22311 | 1739.46 | 0.00 | 0.00 | 0.00 | 1739.46 |
| Rodriguez, Janelle,26887 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Nath, Leonard, L,12637 | 6845.12 | 0.00 | 0.00 | 2049.10 | 4796.02 |
| Cox, Isaiah, E,13584 | 8361.29 | 3578.27 | 0.00 | 0.00 | 4783.02 |
| Kovár, Abby, K,25605 | 600.46 | 0.00 | 0.00 | 600.46 | 0.00 |
| Li, Jeffery,17969 | 3040.31 | 0.00 | 0.00 | 2443.35 | 596.96 |
| Sara, Andre, M,13661 | 5913.24 | 3578.27 | 0.00 | 0.00 | 2334.97 |
| Suri, Francisco,22828 | 2451.30 | 0.00 | 0.00 | 2451.30 | 0.00 |
| Srini, Ebony, A,17959 | 2748.83 | 0.00 | 0.00 | 2181.56 | 567.27 |
Generated 2025-12-23 05:08:10.486 UTC