[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 8 > < TAKE 32 >
32 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Long, Richard, A,24264 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Simmons, Maria, B,28087 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Munoz, Lawrence, C,16857 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Griffin, Brittany, W,20097 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Sun, Jeffery, J,24864 | 155.72 | 0.00 | 0.00 | 0.00 | 155.72 |
| Washington, Antonio, K,11810 | 5973.24 | 0.00 | 3578.27 | 0.00 | 2394.97 |
| Patel, Andre, R,16415 | 4930.68 | 0.00 | 0.00 | 2443.35 | 2487.33 |
| Wilson, Benjamin,14443 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Gonzalez, Rebecca,22763 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Wright, Gabriel,24403 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Jai, Cameron, F,13361 | 4765.63 | 0.00 | 0.00 | 2443.35 | 2322.28 |
| Rivera, Megan, C,15527 | 1622.47 | 0.00 | 0.00 | 782.99 | 839.48 |
| Stewart, Angela,13301 | 66.96 | 0.00 | 0.00 | 0.00 | 66.96 |
| Price, Kayla,28188 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chande, Donna,24118 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Lewis, Ian,12707 | 5948.23 | 0.00 | 3578.27 | 0.00 | 2369.96 |
| Martinez, Ashley,11166 | 87.96 | 0.00 | 0.00 | 0.00 | 87.96 |
| She, Tara,24185 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Bryant, Alexis, A,12417 | 59.27 | 0.00 | 0.00 | 0.00 | 59.27 |
| Miller, Natalie, R,25910 | 4623.83 | 0.00 | 3399.99 | 0.00 | 1223.84 |
| King, Marcus,22152 | 1205.47 | 0.00 | 0.00 | 0.00 | 1205.47 |
| Zhu, Heather,22426 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Li, Ronnie,15650 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Fernandez, Pedro, Y,14932 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Raji, Dustin,20568 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Oliver, Brad, K,26048 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Hernandez, Thomas,13377 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Coleman, Miranda,17620 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Huang, Jessie,12662 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Gutierrez, Ebony, R,25975 | 5807.03 | 0.00 | 3399.99 | 0.00 | 2407.04 |
| Hernandez, Isabella,13220 | 4682.53 | 0.00 | 2181.56 | 0.00 | 2500.97 |
| Wright, Julia, M,11129 | 5873.26 | 0.00 | 3578.27 | 2294.99 | 0.00 |
Generated 2025-12-24 06:17:20.963 UTC