[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1171 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Li, Rosa,17675 | 124.99 | 0.00 | 0.00 | 0.00 | 124.99 | 0.00 |
| Wilson, Nicole,27375 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 | 0.00 |
| James, Alexandra,12822 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 | 0.00 |
| Hayes, Blake, G,16778 | 2541.32 | 0.00 | 0.00 | 0.00 | 2541.32 | 0.00 |
| Sanchez, Isabella, D,27055 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 | 0.00 |
| Coleman, Kayla, L,12048 | 133.96 | 0.00 | 0.00 | 0.00 | 133.96 | 0.00 |
| Murphy, Jada,15252 | 1552.48 | 0.00 | 0.00 | 782.99 | 769.49 | 0.00 |
| Brown, James, C,11192 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 | 0.00 |
| Jenkins, Maria, L,12068 | 93.98 | 0.00 | 0.00 | 0.00 | 93.98 | 0.00 |
| Carter, Edward,23824 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Ward, Morgan,15569 | 3077.98 | 0.00 | 0.00 | 782.99 | 2294.99 | 0.00 |
| Patterson, Dalton, A,16912 | 2380.47 | 0.00 | 0.00 | 0.00 | 2380.47 | 0.00 |
| Coleman, Elijah,23695 | 150.93 | 0.00 | 0.00 | 0.00 | 150.93 | 0.00 |
| Diaz, Maria, A,15771 | 3174.95 | 0.00 | 0.00 | 782.99 | 2391.96 | 0.00 |
| Taylor, Katherine, B,18607 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 | 0.00 |
| Hernandez, Rebecca,20944 | 226.49 | 0.00 | 0.00 | 0.00 | 226.49 | 0.00 |
| Coleman, Isabella, D,27136 | 1223.84 | 0.00 | 0.00 | 0.00 | 1223.84 | 0.00 |
| Harrison, Nelson, J,14823 | 4392.74 | 0.00 | 3578.27 | 0.00 | 814.47 | 0.00 |
| Rodriguez, Abigail,22301 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Sai, Dominic, A,26223 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 | 0.00 |
| Williams, Olivia, K,21811 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 | 0.00 |
| Green, Jenna, J,11527 | 39.58 | 0.00 | 0.00 | 0.00 | 39.58 | 0.00 |
| Bradley, Dakota, D,15884 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Howard, Emma,20523 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Miller, Lucas, L,12495 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 | 0.00 |
| Navarro, Michele, S,12809 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Jones, Anthony, L,13461 | 4476.55 | 0.00 | 0.00 | 2181.56 | 2294.99 | 0.00 |
| Bradley, Alyssa, C,15677 | 7200.86 | 0.00 | 0.00 | 2443.35 | 4757.51 | 0.00 |
| Ramirez, Riley, E,26544 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 | 0.00 |
| Bryant, Grace, J,20371 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 | 0.00 |
| Sanders, Victoria,29078 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 | 0.00 |
| Hall, Evan,18877 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Shan, Lacey, K,14957 | 2807.03 | 0.00 | 0.00 | 2181.56 | 625.47 | 0.00 |
| Ross, Jacqueline,18918 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 | 0.00 |
| Thomas, Justin, J,25860 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 | 0.00 |
| Ferrier, Gilbert, I,19825 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Wright, Adam,17525 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| McDonald, Donald, E,18886 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Vazquez, Ebony, B,19176 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 | 0.00 |
| James, Gabrielle,12725 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 | 0.00 |
| Bennett, Emily, A,18682 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Srini, George,16136 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 | 0.00 |
| Simmons, Nathan, M,11043 | 47.98 | 0.00 | 0.00 | 0.00 | 47.98 | 0.00 |
| Hughes, Dylan, C,13951 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Hughes, Spencer,17591 | 2337.27 | 0.00 | 0.00 | 0.00 | 2337.27 | 0.00 |
| Arun, Veronica, J,18634 | 2427.37 | 0.00 | 699.10 | 0.00 | 1728.27 | 0.00 |
| Kovar, Troy, J,23604 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Suri, Darren,17964 | 5750.36 | 0.00 | 0.00 | 2181.56 | 3568.80 | 0.00 |
| Weber, Darren, A,22563 | 12.98 | 0.00 | 0.00 | 0.00 | 12.98 | 0.00 |
| Harris, Julia, T,15977 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Walker, Natalie,12894 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 | 0.00 |
| Kapoor, Raymond, L,20928 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 | 0.00 |
| Lewis, Sarah, E,12028 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 | 0.00 |
| Andersen, Alison,27947 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Gray, Riley,14351 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 | 0.00 |
| Rogers, Morgan, B,11674 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 | 0.00 |
| Raji, Priscilla, R,13832 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 | 0.00 |
| Gomez, Dwayne,12295 | 174.17 | 0.00 | 0.00 | 0.00 | 174.17 | 0.00 |
| Cooper, Melissa,20073 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 | 0.00 |
| King, Noah,25876 | 4629.07 | 0.00 | 3374.99 | 0.00 | 1254.08 | 0.00 |
Generated 2026-01-04 05:47:13.477 UTC