[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Gomez, Tabitha, L,16688 | 6081.10 | 3578.27 | 0.00 | 2502.83 | 0.00 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ortega, Renee,18447 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Gill, Mallory, P,16698 | 197.88 | 0.00 | 0.00 | 0.00 | 197.88 |
| Lu, Krystal,17049 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Navarro, Francis, J,27520 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Zhou, Jon, L,11060 | 8153.02 | 3399.99 | 0.00 | 2319.99 | 2433.04 |
| Lopez, Manuel, M,14050 | 5650.24 | 0.00 | 0.00 | 3295.26 | 2354.98 |
| Ashe, Briana,22940 | 4207.32 | 0.00 | 0.00 | 4207.32 | 0.00 |
| Gomez, Victor, I,28203 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| Shen, Shawn,19270 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Johnsen, Ross,19618 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Xu, Jessie, R,27517 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gill, Eddie, J,12715 | 74.54 | 0.00 | 0.00 | 64.97 | 9.57 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 2049.10 | 3568.82 |
| Allen, Logan,15812 | 81.25 | 0.00 | 0.00 | 0.00 | 81.25 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 0.00 | 804.48 |
| Van, Cassandra,13525 | 4607.23 | 0.00 | 0.00 | 2071.42 | 2535.81 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raji, Willie, T,11070 | 8165.55 | 0.00 | 3399.99 | 2345.22 | 2420.34 |
| Luo, Casey,11072 | 8194.00 | 0.00 | 3399.99 | 2395.96 | 2398.05 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Alonso, Diane, M,20630 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Kovár, Whitney,13105 | 5585.45 | 0.00 | 0.00 | 2049.10 | 3536.35 |
| Raji, Devon, D,21898 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Zhu, Louis,14858 | 196.97 | 0.00 | 0.00 | 187.98 | 8.99 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Perez, Cesar, L,27982 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 0.00 | 4843.98 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Raje, Tara, F,28483 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Suarez, Carolyn, B,18222 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Zhou, Kelvin,20231 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 34.99 | 82.97 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Liu, Clarence,19797 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Martinez, Anna, J,12994 | 6855.44 | 0.00 | 0.00 | 2071.42 | 4784.02 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 2337.27 | 2419.06 |
| Sara, Edgar, A,11104 | 8173.03 | 0.00 | 3399.99 | 2334.98 | 2438.06 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Tang, Louis, A,18292 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Lopez, Brenda,26592 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 0.00 | 1714.97 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Gomez, Adrienne,11920 | 8156.32 | 0.00 | 3374.99 | 0.00 | 4781.33 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Rivera, Devin, J,25109 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Lu, Christy,17062 | 91.26 | 0.00 | 0.00 | 91.26 | 0.00 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Zhu, Jessie, D,12666 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Wright, Haley,26036 | 88.98 | 0.00 | 0.00 | 0.00 | 88.98 |
| Serrano, Marvin, E,17316 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Ma, Jorge, O,14052 | 86.26 | 0.00 | 0.00 | 27.28 | 58.98 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Chande, Raul, L,21176 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Zhou, Rafael, A,24494 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Andersen, Kelvin, C,21366 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 101.93 | 7.95 |
| Perez, Geoffrey, P,21000 | 2721.55 | 0.00 | 2181.56 | 0.00 | 539.99 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Diaz, Nelson, C,21387 | 2745.33 | 0.00 | 2181.56 | 0.00 | 563.77 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Wang, Erica, J,22168 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Suri, Barry,15253 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Lu, Sandra, N,13521 | 4514.77 | 0.00 | 0.00 | 4514.77 | 0.00 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 1000.44 | 1147.77 | 0.00 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Nath, Michele, L,11056 | 8207.50 | 3374.99 | 0.00 | 2413.45 | 2419.06 |
| Martin, Casey, J,22962 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ma, Jessie,29092 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Pal, Willie, J,11755 | 46.25 | 0.00 | 0.00 | 0.00 | 46.25 |
Generated 2025-11-02 04:42:49.479 UTC