[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xu, Mindy,20246 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Arthur, Regina, A,19089 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Moore, Michael,17247 | 4432.72 | 3578.27 | 0.00 | 0.00 | 854.45 |
| Jai, Rafael, L,17323 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 2294.99 | 2393.06 |
| Guo, Lacey,16744 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Liu, Steve, V,23523 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Chande, Bonnie, L,23992 | 3167.82 | 0.00 | 0.00 | 2443.35 | 724.47 |
| Shen, Shawn,19270 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Hill, Aaron,25818 | 35.96 | 0.00 | 0.00 | 0.00 | 35.96 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Martinez, Kari,19609 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Xu, Arturo,13619 | 6808.10 | 0.00 | 0.00 | 2049.10 | 4759.00 |
| Rodriguez, Rachael, M,11944 | 4776.27 | 0.00 | 3374.99 | 609.96 | 791.32 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 549.98 | 0.00 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Pal, Christy, R,18739 | 5371.74 | 0.00 | 3578.27 | 1793.47 | 0.00 |
| Tang, Christy, R,23660 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 93.49 | 53.99 |
| Raje, Gregory, C,22911 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zheng, Kristen, J,24463 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Cai, Jeffery, A,15582 | 2907.56 | 0.00 | 0.00 | 2049.10 | 858.46 |
| Russell, Seth,25138 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Suarez, Alfredo,19601 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Blanco, Natasha,15808 | 4424.08 | 0.00 | 0.00 | 2049.10 | 2374.98 |
| Hu, Ramon,23439 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Alvarez, Tabitha,15028 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Ramos, Cindy, G,11361 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Moreno, Felicia, A,12987 | 6759.47 | 0.00 | 0.00 | 2071.42 | 4688.05 |
| Williams, Wyatt, E,19614 | 6217.21 | 0.00 | 3578.27 | 0.00 | 2638.94 |
| Huang, Valerie, J,26745 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 0.00 | 4761.03 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Guo, Jaclyn,13119 | 6829.45 | 0.00 | 0.00 | 2071.42 | 4758.03 |
| Coleman, Jocelyn,20606 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Gao, Stacey,16662 | 4355.71 | 3578.27 | 0.00 | 777.44 | 0.00 |
| Cai, Alvin, D,11115 | 35.23 | 0.00 | 0.00 | 27.28 | 7.95 |
| Gonzalez, Joel, A,15043 | 3846.89 | 0.00 | 0.00 | 2071.42 | 1775.47 |
| Prasad, Henry, M,24364 | 3965.52 | 0.00 | 0.00 | 2181.56 | 1783.96 |
| Huang, Tamara, E,14053 | 86.26 | 0.00 | 0.00 | 86.26 | 0.00 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Hernandez, Clinton,29462 | 854.82 | 0.00 | 0.00 | 0.00 | 854.82 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 0.00 | 96.75 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Ye, Claudia, J,19102 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhou, Alan,16480 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Zheng, Laura,16701 | 4426.74 | 3578.27 | 0.00 | 848.47 | 0.00 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Jimenez, Joy,28312 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Washington, Julian, C,23330 | 31.97 | 0.00 | 0.00 | 0.00 | 31.97 |
| Yuan, Carl, P,24160 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Sanders, Gabriella,11906 | 8151.00 | 0.00 | 3374.99 | 2391.94 | 2384.07 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Goel, Drew,17352 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 24.49 | 153.96 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rubio, Mallory, S,11098 | 88.96 | 0.00 | 0.00 | 29.98 | 58.98 |
| Serrano, Hector, K,28308 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Andersen, Jenny,20259 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Sanchez, Francisco, D,21172 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| She, Alicia, W,17250 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 29.99 | 10.24 |
| Martinez, Bruce, D,18452 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Ma, Warren, A,19762 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Goel, Lacey, N,18704 | 33.26 | 0.00 | 0.00 | 30.97 | 2.29 |
| Gomez, Victor, I,28203 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Griffin, Rachel,18255 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Madan, Cassandra, D,29068 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Shan, Franklin, C,27718 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 0.00 | 2049.10 | 4813.04 |
| Wu, Mandy,18309 | 6090.59 | 0.00 | 3578.27 | 2512.32 | 0.00 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 159.00 | 182.97 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Prasad, George, C,15767 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Perry, Madison, R,23308 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhou, Carol, L,24454 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Rodriguez, Heidi, L,25120 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Navarro, Jill,22003 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Van, Brenda, J,24890 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Yuan, Alicia,25225 | 2129.92 | 0.00 | 0.00 | 1000.44 | 1129.48 |
| Prasad, Levi,25705 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Mehta, Denise,13080 | 6844.41 | 0.00 | 0.00 | 2049.10 | 4795.31 |
| Gill, Stacy,12679 | 187.98 | 0.00 | 0.00 | 24.99 | 162.99 |
| Romero, Jacquelyn,25815 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| She, Kelli, J,24889 | 2269.91 | 0.00 | 0.00 | 2269.91 | 0.00 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Chen, Erica, P,18308 | 6037.89 | 0.00 | 3578.27 | 2459.62 | 0.00 |
| Arun, Ruth, S,17294 | 4355.71 | 3578.27 | 0.00 | 0.00 | 777.44 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
Generated 2025-11-07 22:11:52.183 UTC