[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1306 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 0.00 | 3399.99 | 0.00 | 4737.01 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 0.00 | 61.53 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 2181.56 | 1717.93 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Huang, Arturo,28952 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Sharma, Jodi, N,18260 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Rai, Nina,14018 | 63.87 | 0.00 | 0.00 | 0.00 | 63.87 |
| Zhou, Ernest, P,15792 | 2645.40 | 0.00 | 0.00 | 2071.42 | 573.98 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Ms., Salavaria, Sharon,11964 | 8173.53 | 0.00 | 3399.99 | 0.00 | 4773.54 |
| Kumar, Mindy, R,12700 | 6860.44 | 0.00 | 0.00 | 2071.42 | 4789.02 |
| Li, Jaclyn,18281 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Gill, Diane,15578 | 4509.90 | 0.00 | 0.00 | 2071.42 | 2438.48 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Alvarez, Kristy,15588 | 4486.07 | 0.00 | 0.00 | 2049.10 | 2436.97 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Subram, Ann, M,18693 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Taylor, Jennifer,18470 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ross, Julian,11363 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 0.00 | 2543.44 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Nara, Johnny, R,18489 | 6081.10 | 0.00 | 3578.27 | 0.00 | 2502.83 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Serrano, Lori,17066 | 105.75 | 0.00 | 0.00 | 0.00 | 105.75 |
| Madan, Francisco, S,25706 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Serrano, Shannon, R,18303 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| McDonald, Kaitlin,18493 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Griffin, Noah, E,29118 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Wu, Christy, D,25568 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Gill, Diana,25710 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Raje, Louis, M,25707 | 1262.06 | 0.00 | 699.10 | 0.00 | 562.96 |
| Flores, Katherine,21180 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 0.00 | 2484.94 |
| Ye, Ramon,11357 | 4943.80 | 0.00 | 3374.99 | 0.00 | 1568.81 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Malhotra, Emmanuel,18332 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| She, Gregory,18458 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Xu, Edwin, J,25272 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Navarro, Jonathon,18722 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Ortega, Joanna,17909 | 4761.74 | 0.00 | 3578.27 | 0.00 | 1183.47 |
| Zhao, Micah,18708 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Gill, Gary, B,25108 | 2199.41 | 0.00 | 0.00 | 1000.44 | 1198.97 |
| Anand, Katrina, L,18726 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Xie, Ricardo,18710 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Campbell, Seth,18716 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Alonso, Naomi,15830 | 2680.38 | 0.00 | 0.00 | 2071.42 | 608.96 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Lin, Laura, L,11462 | 8116.33 | 0.00 | 3374.99 | 0.00 | 4741.34 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Gutierrez, Jaime, C,11457 | 8211.48 | 0.00 | 3374.99 | 0.00 | 4836.49 |
| Rivera, Steven, T,19083 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Luo, Tamara,18738 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Gonzalez, Ebony,11034 | 6491.32 | 0.00 | 3399.99 | 0.00 | 3091.33 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Saunders, Patricia, J,19565 | 5308.24 | 0.00 | 3578.27 | 0.00 | 1729.97 |
| Yuan, Maurice,24380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Garcia, Dalton, M,18768 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Guo, Micah, M,24163 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Ortega, Linda, C,11756 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Shan, Brad, H,19605 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Stewart, Margaret, C,29096 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 0.00 | 4714.05 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Sun, Candice, A,19568 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Deng, Devon, H,19967 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Liang, Candice,22208 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Garcia, Ruben,19613 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Ortega, Julio, M,11892 | 8119.03 | 0.00 | 3399.99 | 0.00 | 4719.04 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 0.00 | 4749.50 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Raman, Raymond, R,19588 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Liu, Darryl,19947 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
Generated 2026-01-04 05:39:42.872 UTC