[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 30 < SKIP 375 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Munoz, Audrey, V,12003 | 8256.50 | 0.00 | 3374.99 | 0.00 | 4881.51 |
| Zhu, Lacey,24167 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Barnes, Angelica,15128 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Suarez, Pedro, A,24611 | 2219.42 | 0.00 | 1000.44 | 1218.98 | 0.00 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Hall, Mary, R,20277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Taylor, Devin, L,12248 | 3939.98 | 0.00 | 3399.99 | 0.00 | 539.99 |
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Nath, Latoya, A,27582 | 561.92 | 0.00 | 0.00 | 0.00 | 561.92 |
| Gao, Lisa, A,19753 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Sergio, L,15123 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Serrano, Derrick,16707 | 4377.75 | 0.00 | 3578.27 | 0.00 | 799.48 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Gomez, Marc, J,21880 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Liu, Randy,15015 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 49.97 | 59.91 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Morgan, Jared, A,28213 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 0.00 | 114.46 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Xu, Colleen, C,18325 | 108.85 | 0.00 | 0.00 | 0.00 | 108.85 |
| Zhao, Alisha, M,21988 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Bell, Isabella,27698 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Lal, Donna,25812 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Schmidt, Shane,17922 | 4821.72 | 0.00 | 3578.27 | 0.00 | 1243.45 |
| Mr., Schmidt, Irving, W,12669 | 6791.10 | 0.00 | 0.00 | 2049.10 | 4742.00 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Gomez, Teresa, D,24164 | 2760.02 | 0.00 | 0.00 | 2181.56 | 578.46 |
| Perez, Kyle, J,16180 | 4386.37 | 0.00 | 0.00 | 2049.10 | 2337.27 |
| Suarez, Billy, M,17287 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Martin, Natasha, N,27490 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Tang, Ashlee, D,11369 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Raman, César, C,24004 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Anand, Katrina, L,18726 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Serrano, Orlando,19561 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Madan, Candace,22409 | 2746.04 | 0.00 | 0.00 | 2181.56 | 564.48 |
| Gill, Jimmy,29098 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Yuan, Franklin,24594 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 0.00 | 2181.56 | 2481.82 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 0.00 | 105.22 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Andersen, Marshall, V,15786 | 4366.07 | 0.00 | 0.00 | 2049.10 | 2316.97 |
| Sanchez, Levi, A,27745 | 617.47 | 0.00 | 0.00 | 617.47 | 0.00 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sharma, Donna,11998 | 6962.10 | 0.00 | 3374.99 | 0.00 | 3587.11 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Hernandez, Joe,15154 | 84.98 | 0.00 | 0.00 | 0.00 | 84.98 |
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 0.00 | 4768.01 |
| Smith, Kristi, M,21962 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Raji, Jaime, L,15037 | 3856.38 | 0.00 | 0.00 | 2071.42 | 1784.96 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Alonso, Raquel,17313 | 51.92 | 0.00 | 0.00 | 0.00 | 51.92 |
| Gomez, Nelson, L,29053 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Walker, Seth, E,27689 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Xu, Dawn,27873 | 1249.84 | 0.00 | 0.00 | 1249.84 | 0.00 |
| Sun, Tamara, L,19976 | 44.04 | 0.00 | 0.00 | 0.00 | 44.04 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Torres, Eddie, L,21985 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Ruiz, Kristine, J,24607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Anand, Rafael,29306 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Sai, Abby, L,11101 | 8262.52 | 0.00 | 3399.99 | 2439.99 | 2422.54 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Mehta, Jay, S,15035 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 0.00 | 2478.34 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Carlson, Lawrence, L,22064 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Huang, Dawn, E,11943 | 4734.29 | 0.00 | 3374.99 | 539.99 | 819.31 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Martin, Randall, B,19560 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Nath, Dawn, L,11759 | 8054.05 | 0.00 | 3374.99 | 0.00 | 4679.06 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Kumar, Shawna, L,19085 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Martinez, Lydia,24169 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Xie, Kurt, A,14344 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Gomez, Andy,18721 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Rodriguez, Francisco,24361 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Andersen, Shawna, C,19556 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
Generated 2025-12-24 07:06:13.228 UTC