[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 0 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 4242.31 | 0.00 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Gao, Trisha, A,28953 | 2462.55 | 0.00 | 0.00 | 2462.55 | 0.00 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Alvarez, Albert, R,16624 | 5938.25 | 3578.27 | 0.00 | 0.00 | 2359.98 |
| She, Nina,22961 | 3891.54 | 0.00 | 0.00 | 3891.54 | 0.00 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 0.00 | 2049.10 | 2479.94 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 2520.27 | 0.00 |
| Garcia, Ivan, L,17354 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Suri, Evelyn, A,21223 | 56.98 | 0.00 | 0.00 | 56.98 | 0.00 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Moreno, Kathleen, C,15234 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Serrano, Kristine,28940 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 0.00 | 1149.47 |
| Rubio, Mallory, S,11098 | 88.96 | 0.00 | 0.00 | 29.98 | 58.98 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 27.28 | 121.42 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Moreno, Tanya,11139 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Mehta, Marco,11007 | 8211.00 | 3399.99 | 0.00 | 4811.01 | 0.00 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Ward, Haley, J,16631 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Zhou, Kelvin,20231 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Nara, Clayton,11768 | 8139.04 | 0.00 | 3399.99 | 2319.99 | 2419.06 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 75.97 | 28.99 |
| Raman, Roy,16348 | 5918.24 | 3578.27 | 0.00 | 0.00 | 2339.97 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 37.27 | 62.98 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 34.99 | 82.97 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Rodriguez, Monica, J,28951 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Sara, Cesar, C,22172 | 2932.30 | 0.00 | 0.00 | 2181.56 | 750.74 |
| Ramos, Briana, J,14303 | 3636.91 | 0.00 | 0.00 | 2049.10 | 1587.81 |
| Vazquez, Jésus,26665 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 34.56 | 26.97 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Chavez, Corey, R,15731 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Beck, Donna, J,18247 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Raji, Christy,15584 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 0.00 | 4694.04 |
| Kapoor, Denise, M,18725 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Simmons, Jordyn,16494 | 5961.20 | 3578.27 | 0.00 | 0.00 | 2382.93 |
| Cook, Kaylee,11904 | 8214.50 | 0.00 | 3399.99 | 2395.45 | 2419.06 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 0.00 | 2049.10 | 4730.32 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 3563.84 | 0.00 |
| Alvarez, Janet, G,11006 | 8119.03 | 3399.99 | 0.00 | 2334.97 | 2384.07 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 143.45 | 48.97 |
| Ramos, Theresa, G,11031 | 6478.60 | 3399.99 | 0.00 | 0.00 | 3078.61 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 2358.97 | 2419.06 |
| Rodriguez, Arthur,15438 | 3788.68 | 0.00 | 0.00 | 2071.42 | 1717.26 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 2394.97 | 2384.07 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 4731.32 | 0.00 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 1308.31 | 2334.97 |
| Sharma, Raul, E,16347 | 5918.50 | 3578.27 | 0.00 | 0.00 | 2340.23 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Ms., Rusek, Pearlie, J.,21945 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 80.11 | 0.00 |
| Gill, Monique, L,17727 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 2049.10 | 0.00 | 4843.98 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Allen, Hailey, C,26759 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 0.00 | 4734.05 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 0.00 | 1714.97 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 0.00 | 2482.23 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Price, Megan,24907 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Hayes, Eric, A,22964 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Carlson, Frank,11896 | 8117.97 | 0.00 | 3374.99 | 2341.97 | 2401.01 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Diaz, Samuel,14065 | 5608.55 | 0.00 | 0.00 | 2071.42 | 3537.13 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Romero, Renee, E,16639 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Yang, Leah, J,15186 | 59.48 | 0.00 | 0.00 | 0.00 | 59.48 |
| Rai, Alejandro, R,21990 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Patterson, Melissa, E,12668 | 6839.46 | 0.00 | 2071.42 | 0.00 | 4768.04 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Nara, Kelsey, A,24905 | 2195.91 | 0.00 | 0.00 | 1000.44 | 1195.47 |
| Yuan, Christine,11046 | 6616.81 | 3374.99 | 0.00 | 0.00 | 3241.82 |
| She, Tonya, L,16521 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Misty,25708 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Black, Rafael,11966 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Hall, Jesse,26133 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 0.00 | 2071.42 | 4800.01 |
Generated 2025-11-01 21:28:52.610 UTC