[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Gonzales, Brandon, D,28824 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Patterson, Nathan, W,17532 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Raji, Priscilla, R,13832 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 | 0.00 |
| Alonso, Alberto,25350 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 | 0.00 |
| Kelly, Paige,23728 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 | 0.00 |
| Gonzales, Gloria, A,23174 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 | 0.00 |
| Wilson, Joseph, L,24520 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 | 0.00 |
| Cook, Isabella, D,13172 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 | 0.00 |
| Sai, Douglas, A,20833 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 | 0.00 |
| Watson, Destiny, W,24593 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Perez, Edward, J,26471 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 | 0.00 |
| Diaz, Morgan, L,20296 | 1145.48 | 0.00 | 0.00 | 0.00 | 1145.48 | 0.00 |
| Mehta, Summer, E,18415 | 2454.98 | 0.00 | 0.00 | 0.00 | 2454.98 | 0.00 |
| Cook, Jessica, J,22131 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 | 0.00 |
| Simmons, Nathan, M,11043 | 47.98 | 0.00 | 0.00 | 0.00 | 47.98 | 0.00 |
| Adams, Jose, J,15477 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Dominguez, Monique, C,22778 | 722.77 | 0.00 | 0.00 | 0.00 | 722.77 | 0.00 |
| Simpson, Shawna,28454 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 | 0.00 |
| King, Jason,18809 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Thompson, Victoria, A,13857 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 | 0.00 |
| Perry, Carson, C,13066 | 3033.31 | 0.00 | 2443.35 | 0.00 | 589.96 | 0.00 |
| Alexander, Marcus, M,16102 | 563.96 | 0.00 | 0.00 | 0.00 | 563.96 | 0.00 |
| Ortega, Casey, D,21681 | 799.42 | 0.00 | 0.00 | 0.00 | 799.42 | 0.00 |
| Young, Sydney, K,21006 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 | 0.00 |
| Jai, Lindsay, R,17718 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 | 0.00 |
| Dominguez, Marc, J,12539 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 | 0.00 |
| Howard, Maria,23035 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 | 0.00 |
| Xu, Kenneth,12646 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Martinez, Justin, A,16583 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 | 0.00 |
| Ward, Jeremy, D,24951 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 | 0.00 |
| Raje, Alison, J,12345 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Rivera, Gabriella,25771 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 | 0.00 |
| Shan, David,18680 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 | 0.00 |
| Fernandez, Ebony,24663 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 | 0.00 |
| Morris, Melissa, A,26340 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 | 0.00 |
| Xie, Deborah, C,12713 | 4441.38 | 0.00 | 0.00 | 2071.42 | 2369.96 | 0.00 |
| Perez, Noah,14482 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 | 0.00 |
| Carter, Jackson, S,20010 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Taylor, Matthew, L,20511 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 | 0.00 |
| Raje, Shawna, F,19046 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 | 0.00 |
| Hayes, Xavier,29039 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Smith, Joseph, T,20513 | 74.46 | 0.00 | 0.00 | 0.00 | 74.46 | 0.00 |
| Xu, Misty,22615 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Mr., Selikoff, Steven,16737 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ramos, Jacquelyn, Y,17836 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 | 0.00 |
| Johnson, Rachel,18419 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 | 0.00 |
| Reed, Anna, S,27271 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 | 0.00 |
| Bryant, Kevin,11587 | 4540.38 | 0.00 | 0.00 | 2049.10 | 2491.28 | 0.00 |
| Ferrier, Marc,12509 | 82.85 | 0.00 | 0.00 | 0.00 | 82.85 | 0.00 |
| Russell, Luke, E,15344 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Gray, Emma, C,23374 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 | 0.00 |
| Wood, Hannah,12717 | 5883.25 | 0.00 | 3578.27 | 0.00 | 2304.98 | 0.00 |
| Zhang, Elijah,28789 | 7.95 | 0.00 | 0.00 | 0.00 | 0.00 | 7.95 |
| Mitchell, Carlos,20770 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 | 0.00 |
| James, Olivia,16755 | 2316.97 | 0.00 | 0.00 | 0.00 | 2316.97 | 0.00 |
| Bradley, Katherine,23596 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 | 0.00 |
| Kelly, Lauren, A,26462 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 | 0.00 |
| Perry, Isabelle, A,23501 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 | 0.00 |
| Collins, Jordan,20398 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 | 0.00 |
| Brown, Logan, C,19135 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
Generated 2026-01-04 05:12:49.000 UTC