[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 16 < SKIP 2000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Martin, Briana, L,15213 | 2818.59 | 0.00 | 0.00 | 2049.10 | 769.49 |
| Johnson, Brianna, J,17319 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Blanco, Ricky, F,16606 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Luo, Nichole, A,29296 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Raman, Cindy,16157 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Prasad, Francisco,16628 | 187.58 | 0.00 | 0.00 | 0.00 | 187.58 |
| Rubio, Jessie, J,27868 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Parker, Gabriella,21394 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Diaz, Devin, D,15829 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Zhao, Jorge,16711 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Romero, Meredith, J,29452 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Rana, Marco, K,24473 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Williams, Nicholas, A,25809 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Luo, Colleen, E,15208 | 2951.56 | 0.00 | 0.00 | 2049.10 | 902.46 |
| Fernandez, Marie,28929 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Gill, Mathew, M,27486 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Alexander, Elizabeth,13089 | 6800.45 | 0.00 | 0.00 | 2071.42 | 4729.03 |
| Lal, Carl, C,28950 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Xu, Brad,26157 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Patel, Stanley, L,24915 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Franklin,24594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Sai, Monica, L,29055 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Becker, Keith, P,27515 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Xu, Barbara,14074 | 59.88 | 0.00 | 0.00 | 0.00 | 59.88 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Subram, Martin, S,19590 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Deng, Tasha,11459 | 8141.33 | 0.00 | 3399.99 | 0.00 | 4741.34 |
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 0.00 | 4828.02 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanz, Linda, P,22945 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Moreno, Danny, M,29458 | 811.32 | 0.00 | 0.00 | 0.00 | 811.32 |
| Guo, Lisa, S,17314 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Mehta, Cindy, A,21943 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Gutierrez, Orlando,25920 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| He, Jorge,20268 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Wu, Warren, M,15602 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 0.00 | 2049.10 | 3645.80 |
| Raji, Willie, T,11070 | 8165.55 | 0.00 | 3399.99 | 2345.22 | 2420.34 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Raji, Carly, L,23346 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Yuan, Ricardo,16674 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Alvarez, Roy, A,16709 | 143.94 | 0.00 | 0.00 | 0.00 | 143.94 |
| Chander, Gregory, J,22001 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Diaz, Gerald, M,25118 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Vance, Jillian, D,15230 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Green, Fernando,17258 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Zheng, Vincent,18496 | 6121.71 | 0.00 | 3578.27 | 0.00 | 2543.44 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Cook, Isaac, M,13994 | 4528.75 | 0.00 | 0.00 | 2071.42 | 2457.33 |
| Sanchez, Olivia, J,14278 | 177.46 | 0.00 | 0.00 | 0.00 | 177.46 |
| Xu, Jaclyn,24252 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Xie, Drew, A,20218 | 104.69 | 0.00 | 0.00 | 0.00 | 104.69 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Alonso, Diana, L,24590 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Rai, Rafael, H,18715 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Raji, Wayne, A,26161 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Sanz, Reginald, K,17522 | 74.95 | 0.00 | 0.00 | 0.00 | 74.95 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Becker, Jenny,17290 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Foster, Maria, E,28715 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Hernandez, Javier, A,16156 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Tang, Willie, A,25939 | 1264.57 | 0.00 | 699.10 | 0.00 | 565.47 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Cook, Victoria, J,20620 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Alvin, D,11115 | 35.23 | 0.00 | 0.00 | 0.00 | 35.23 |
| Griffin, Rachel,18255 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Prasad, Meagan,19611 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Vance, Henry,27986 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Chen, Jake,22845 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Hernandez, Wendy, A,15124 | 122.44 | 0.00 | 0.00 | 0.00 | 122.44 |
| Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sai, Lydia, L,13968 | 5181.70 | 0.00 | 0.00 | 2071.42 | 3110.28 |
| Zheng, Rosa, G,16629 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Suri, Holly, M,18286 | 141.55 | 0.00 | 0.00 | 0.00 | 141.55 |
| Diaz, Mallory, V,17289 | 106.95 | 0.00 | 0.00 | 0.00 | 106.95 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 0.00 | 4733.05 |
| Van, Brett,26166 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Torres, Kari,18486 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Arun, Nancy, C,21169 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Weber, Jay, A,25244 | 21.93 | 0.00 | 0.00 | 0.00 | 21.93 |
| Zhu, Roger, J,28098 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 0.00 | 4763.54 |
| Jai, Jaime, M,24894 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Gao, Louis,14666 | 5199.92 | 0.00 | 0.00 | 2049.10 | 3150.82 |
| Gill, Ricky, A,15607 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Zhao, Glenn, C,14221 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
Generated 2026-01-04 05:38:34.757 UTC