[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 124 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 2071.42 | 0.00 | 4749.05 |
| Sharma, Dustin, M,18484 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 49.99 | 49.48 |
| Griffin, Grace,11443 | 8235.00 | 0.00 | 3374.99 | 0.00 | 4860.01 |
| Ross, Julian,11363 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Huang, Vincent, A,18703 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Chen, Erica, P,18308 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Yuan, Mitchell,26744 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Rai, Brad, S,18490 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Lal, Kenneth, J,18701 | 5357.74 | 0.00 | 3578.27 | 1779.47 | 0.00 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Lopez, Savannah,25709 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Rubio, Robyn, A,18469 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Sanchez, Carla,18274 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Hernandez, Monique, J,15138 | 123.45 | 0.00 | 0.00 | 34.99 | 88.46 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Serrano, Joanna, J,26663 | 1976.94 | 0.00 | 0.00 | 782.99 | 1193.95 |
| Martin, Joe,14668 | 5216.69 | 0.00 | 0.00 | 2071.42 | 3145.27 |
| Kumar, Kenneth,11472 | 8165.82 | 0.00 | 3399.99 | 0.00 | 4765.83 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Raji, Corey,25058 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Josue,15207 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Hernandez, Brandi, C,21893 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| Sanchez, Manuel,15126 | 86.26 | 0.00 | 0.00 | 58.98 | 27.28 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Hernandez, Joan, J,21892 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Rubio, Nelson,26433 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Kennedy, Devon, J,13133 | 6813.12 | 0.00 | 0.00 | 2049.10 | 4764.02 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Sanz, Theodore, M,16492 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Zhang, Edwin,15785 | 4454.35 | 0.00 | 0.00 | 2071.42 | 2382.93 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Taylor, Ashley, E,18215 | 150.97 | 0.00 | 0.00 | 0.00 | 150.97 |
| Liang, Brittney, R,26182 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Oliver, Lee,29119 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-11-04 04:20:06.483 UTC