[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 844 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Stacy,28315 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Townsend, Darren,18467 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Yuan, Sharon,12008 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Sai, Ronald, B,13643 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Dominguez, Larry,22197 | 4740.98 | 0.00 | 0.00 | 2181.56 | 2559.42 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Moreno, Larry, W,28207 | 2461.55 | 0.00 | 0.00 | 2461.55 | 0.00 |
| Gomez, Victor, I,28203 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Beck, Ashlee, L,26666 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Sai, Cesar,18243 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Huang, Brent,18220 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Chander, Bethany, K,11446 | 8237.01 | 0.00 | 3399.99 | 2354.98 | 2482.04 |
| Ramos, Marie, A,14308 | 5140.40 | 0.00 | 0.00 | 2049.10 | 3091.30 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Zeng, Suzanne,17918 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Johnson, Emma, M,15136 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Munoz, Felicia, D,20406 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Suri, Rachael, J,18279 | 162.02 | 0.00 | 0.00 | 0.00 | 162.02 |
| Zheng, Colleen,13026 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Blanco, Monique, W,14103 | 3612.22 | 0.00 | 0.00 | 2071.42 | 1540.80 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 0.00 | 4791.52 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Liang, Darryl,26658 | 1390.95 | 0.00 | 0.00 | 1390.95 | 0.00 |
| Diaz, Cheryl, A,11092 | 8110.02 | 0.00 | 3374.99 | 2341.97 | 2393.06 |
| Chande, Lindsay,18244 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 0.00 | 4169.33 | 0.00 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Romero, Julio,22857 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 0.00 | 74.94 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Ramos, Naomi, M,23656 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Wu, Aimee,16690 | 165.07 | 0.00 | 0.00 | 0.00 | 165.07 |
| Martinez, Sarah, S,12670 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Torres, Sebastian, V,25831 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Hernandez, Bruce,17919 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Walker, Seth, E,27689 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alexander, Elizabeth,13089 | 6800.45 | 0.00 | 0.00 | 2071.42 | 4729.03 |
| Ye, Leah,11077 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Rana, Johnathan, R,27497 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Nelson, Natalie, C,22928 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Thomas, Christopher, M,20242 | 6068.45 | 0.00 | 3578.27 | 0.00 | 2490.18 |
| Raji, Dawn, C,20244 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Fernandez, Geoffrey,19963 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Gonzalez, Francisco, L,12245 | 3967.26 | 0.00 | 3399.99 | 0.00 | 567.27 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Bell, Isabella,27698 | 1179.97 | 0.00 | 0.00 | 0.00 | 1179.97 |
| Zhao, Lacey, M,27713 | 1158.96 | 0.00 | 0.00 | 0.00 | 1158.96 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Lin, Dawn, N,15805 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 0.00 | 2071.42 | 4741.35 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Xie, Casey,21217 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Kapoor, Arthur,24483 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Watson, Nathaniel, H,25826 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Lee, David, J,22199 | 4693.88 | 0.00 | 0.00 | 2181.56 | 2512.32 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Dominguez, Robin,16685 | 4183.23 | 0.00 | 3578.27 | 0.00 | 604.96 |
| Suarez, Ruben,14031 | 6964.42 | 0.00 | 0.00 | 2049.10 | 4915.32 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Shan, Connor, C,18901 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Lin, Margaret, C,18306 | 87.77 | 0.00 | 0.00 | 0.00 | 87.77 |
| Rai, Sharon,20225 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 0.00 | 118.96 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Huang, Lacey, J,11951 | 63.52 | 0.00 | 0.00 | 0.00 | 63.52 |
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Luo, Nina,27495 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Campbell, Haley, L,17304 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Carlson, Ebony,13959 | 6858.42 | 0.00 | 0.00 | 2049.10 | 4809.32 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Munoz, Robyn,14214 | 5759.87 | 0.00 | 0.00 | 2049.10 | 3710.77 |
| Gill, Kellie,17292 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 0.00 | 82.25 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Suarez, Linda,16665 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Ma, Todd,19581 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zhu, Clarence, A,18462 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Green, Jonathan, A,17332 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Brown, Cameron, D,13041 | 153.95 | 0.00 | 0.00 | 0.00 | 153.95 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 2382.93 | 2419.06 |
| Mr., Schulte, Scot,15807 | 70.57 | 0.00 | 0.00 | 0.00 | 70.57 |
| Yang, Louis, J,23013 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Navarro, Erik, E,25055 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Martin, Beth, K,23317 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Hector, M,26187 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Martin, Marc, J,11039 | 6636.58 | 0.00 | 3399.99 | 0.00 | 3236.59 |
Generated 2025-12-24 07:37:04.848 UTC