[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > SHUFFLE < SKIP 2000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Black, Mindy, W,18696 | 6149.57 | 0.00 | 3578.27 | 2571.30 | 0.00 |
| Martinez, Fernando,20454 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Hernandez, Roberto,28923 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Raji, Kate, L,11903 | 8108.04 | 0.00 | 3374.99 | 2294.99 | 2438.06 |
| Li, Glenn, A,29295 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Zhou, Carol, L,24454 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Ma, Lacey, K,18723 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Lin, Clayton, M,27492 | 1344.91 | 0.00 | 0.00 | 782.99 | 561.92 |
| Goel, Michele,15041 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Subram, Evelyn, S,21257 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Srini, Manuel,24168 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 2049.10 | 0.00 | 615.96 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Serrano, Mathew, A,29186 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Jenkins, Angela,15722 | 4448.57 | 0.00 | 0.00 | 2049.10 | 2399.47 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Lin, Mandy, C,25035 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 0.00 | 571.72 |
| Yuan, Louis, C,18193 | 4145.54 | 0.00 | 3578.27 | 0.00 | 567.27 |
| Yang, Kevin, F,20605 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 29.99 | 10.24 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Cai, Jessie, A,12249 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Ye, Jenny,25036 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Vance, Ruth, D,17302 | 147.44 | 0.00 | 0.00 | 58.98 | 88.46 |
| Richardson, Abigail, S,14236 | 5710.23 | 0.00 | 0.00 | 2071.42 | 3638.81 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Gutierrez, Latasha, C,15022 | 2999.91 | 0.00 | 0.00 | 2071.42 | 928.49 |
| Thomas, Christopher, M,20242 | 6068.45 | 0.00 | 3578.27 | 0.00 | 2490.18 |
| Zhu, Jake, G,24603 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Dominguez, Gerald, E,20631 | 71.96 | 0.00 | 0.00 | 0.00 | 71.96 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Gonzalez, Veronica, C,23311 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Carlson, Wendy,20220 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 4242.31 | 0.00 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 117.46 | 27.28 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Chapman, Kristi, l,21986 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| She, Stacey,26748 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Hernandez, Logan,12350 | 6791.75 | 0.00 | 2071.42 | 0.00 | 4720.33 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 0.00 | 3518.83 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| She, Bridget, M,19557 | 5358.24 | 0.00 | 3578.27 | 0.00 | 1779.97 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| She, Kathryn, I,26443 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Torres, Alfredo,27685 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 71.58 | 34.98 |
| Raman, Michele,17233 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Nara, Jaclyn, M,11930 | 5035.81 | 0.00 | 3399.99 | 0.00 | 1635.82 |
| Moreno, Casey,20602 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Zhou, Laura, D,12683 | 6801.45 | 0.00 | 2071.42 | 0.00 | 4730.03 |
| Chander, Clarence, E,13982 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2071.42 | 539.99 |
| Gomez, Brandi, M,14675 | 187.98 | 0.00 | 0.00 | 0.00 | 187.98 |
| Reed, Kimberly, D,17311 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Shen, Mitchell, M,22904 | 4759.99 | 0.00 | 0.00 | 2181.56 | 2578.43 |
| Rubio, Deanna, T,19573 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Madan, Meagan,11767 | 8319.51 | 0.00 | 3399.99 | 2475.97 | 2443.55 |
| Lal, Drew, A,28325 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Navarro, Meredith,27703 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 2484.94 | 0.00 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chander, Lindsay, R,19972 | 49.70 | 0.00 | 0.00 | 0.00 | 49.70 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Tang, Wayne, S,13090 | 6812.42 | 0.00 | 0.00 | 2049.10 | 4763.32 |
| Suarez, Daisy, A,18288 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Li, Alejandro, A,27519 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Munoz, Jacquelyn,29115 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| West, Nathan,24370 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Richardson, Katelyn,18930 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Hu, Valerie, M,15044 | 3803.56 | 0.00 | 0.00 | 2049.10 | 1754.46 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Vance, Toni, L,23438 | 123.48 | 0.00 | 0.00 | 0.00 | 123.48 |
| Rodriguez, Francisco,24361 | 3391.03 | 0.00 | 0.00 | 2181.56 | 1209.47 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Shan, Elijah, L,26795 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Ortega, Shannon,26375 | 1971.45 | 0.00 | 0.00 | 782.99 | 1188.46 |
| Wilson, Zachary,25558 | 1307.06 | 699.10 | 0.00 | 0.00 | 607.96 |
| Serrano, Linda,11071 | 110.23 | 0.00 | 0.00 | 42.26 | 67.97 |
| Sanchez, Denise,16703 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| Rai, Tonya,25243 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Diaz, Jacquelyn, K,18747 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 49.99 | 64.97 |
Generated 2025-11-03 15:18:11.549 UTC