[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 720 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Madan, Toni,26668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Xie, Dustin,22204 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Hu, Glenn, R,24897 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sanders, Arianna, E,22859 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wang, Trisha, V,17259 | 4404.73 | 0.00 | 3578.27 | 0.00 | 826.46 |
| Yang, Jon, V,11000 | 8248.99 | 3399.99 | 0.00 | 2341.97 | 2507.03 |
| Madan, Henry, E,17283 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Huang, Sandra, C,16523 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Sharma, Raul, E,16347 | 5918.50 | 0.00 | 3578.27 | 0.00 | 2340.23 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Chapman, Kathryn,11988 | 8078.02 | 0.00 | 3374.99 | 0.00 | 4703.03 |
| Raman, Shane,16661 | 5908.25 | 0.00 | 3578.27 | 0.00 | 2329.98 |
| Diaz, Gloria,25270 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Shen, Shaun,12684 | 6893.08 | 0.00 | 0.00 | 2049.10 | 4843.98 |
| Xu, Alan,16741 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Liu, Autumn, J,20985 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Serrano, Julio,20992 | 4139.75 | 0.00 | 3578.27 | 0.00 | 561.48 |
| Alonso, Kristine,16686 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Powell, Lucas, T,18278 | 158.95 | 0.00 | 0.00 | 0.00 | 158.95 |
| Sharma, Sharon, T,25294 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Ortega, Jessie, J,17051 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Munoz, Deanna,11054 | 8223.02 | 0.00 | 3399.99 | 2403.97 | 2419.06 |
| Zhou, Autumn, L,25229 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Hernandez, Diana, F,11038 | 6437.33 | 0.00 | 3374.99 | 0.00 | 3062.34 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Perez, Joel,16684 | 4158.24 | 0.00 | 3578.27 | 0.00 | 579.97 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| She, Keith, L,26563 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Goel, Christine, A,21231 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 |
| Guo, Lacey,16744 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Lopez, Heidi,11052 | 8131.32 | 0.00 | 3374.99 | 2337.27 | 2419.06 |
| Zheng, Laura,16701 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Goel, Derek,17045 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Gutierrez, Natasha,17048 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Griffin, Brianna, K,16487 | 73.24 | 0.00 | 0.00 | 0.00 | 73.24 |
| Raman, Patricia, T,16702 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Evans, Carlos, J,23538 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 0.00 | 4713.05 |
| Pal, Mitchell, R,16742 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Kapoor, Kaitlin, M,17072 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Lu, Krystal,17049 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Flores, Adam, L,11044 | 6515.30 | 0.00 | 3374.99 | 0.00 | 3140.31 |
| Raji, Tammy, K,17071 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Chande, Dale, K,17242 | 4387.23 | 0.00 | 3578.27 | 0.00 | 808.96 |
| Munoz, Carolyn, L,17315 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Ferrier, Linda, D,13149 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Wilson, Zachary,25558 | 1307.06 | 0.00 | 699.10 | 0.00 | 607.96 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Wu, Micah,17246 | 4380.04 | 0.00 | 3578.27 | 0.00 | 801.77 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gray, Stephanie,17064 | 4506.76 | 0.00 | 3578.27 | 0.00 | 928.49 |
| Patel, Janelle, T,29116 | 17.27 | 0.00 | 0.00 | 0.00 | 17.27 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 0.00 | 2443.35 | 2516.81 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Sai, Molly,14683 | 98.95 | 0.00 | 0.00 | 0.00 | 98.95 |
| Lal, Shaun, H,17056 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Price, Isabella, L,17278 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Alvarez, Tanya,17279 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zhao, Rosa, A,19672 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Flores, Noah,17256 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Li, Karen, K,17921 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Hill, Noah,26192 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Zhang, Aimee,26025 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Zhou, Louis, C,17912 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Kumar, Wayne,17502 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 0.00 | 563.96 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Moreno, Casey,20602 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| Nara, Dustin, M,17910 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Serrano, Orlando,19561 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Navarro, Latasha, L,11100 | 8172.51 | 0.00 | 3374.99 | 0.00 | 4797.52 |
| Raje, Cristina, S,17917 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Pal, Clayton,27721 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Xu, Tracy, L,17916 | 4787.74 | 0.00 | 3578.27 | 0.00 | 1209.47 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Martinez, Daniel, P,17725 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Huang, Jake,19589 | 95.26 | 0.00 | 0.00 | 0.00 | 95.26 |
| Anderson, Blake,11076 | 8159.04 | 0.00 | 3399.99 | 2374.98 | 2384.07 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Xu, Lacey, S,17913 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Ramos, Mathew, E,28961 | 2478.04 | 0.00 | 0.00 | 0.00 | 2478.04 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Deng, April,11117 | 8184.99 | 0.00 | 3399.99 | 2365.94 | 2419.06 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 0.00 | 2049.10 | 4856.99 |
| Kumar, Louis, A,18203 | 4172.25 | 0.00 | 3578.27 | 0.00 | 593.98 |
| Zheng, Dennis, E,25567 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Gonzalez, Phillip, N,18207 | 6089.59 | 0.00 | 3578.27 | 2511.32 | 0.00 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Navarro, Kristine, B,25566 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
Generated 2026-01-04 05:25:03.573 UTC