[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| He, Kelli, A,28872 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 3809.57 | 0.00 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Wang, Micah, C,14676 | 5188.41 | 0.00 | 0.00 | 2049.10 | 3139.31 |
| Hernandez, Orlando, C,21951 | 4923.29 | 0.00 | 2443.35 | 0.00 | 2479.94 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Powell, Jeremy,11048 | 6498.24 | 3374.99 | 0.00 | 0.00 | 3123.25 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 2419.46 | 2461.03 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Mr., Sands, Patrick,14063 | 5676.25 | 0.00 | 0.00 | 3321.26 | 2354.99 |
| Gill, Stacy,12679 | 187.98 | 0.00 | 0.00 | 24.99 | 162.99 |
| Romero, Paula, B,16691 | 4471.74 | 3578.27 | 0.00 | 893.47 | 0.00 |
| Rubio, Kathleen, A,20820 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Huang, Alejandro,11464 | 8128.51 | 0.00 | 3374.99 | 2334.46 | 2419.06 |
| Chen, Cedric, R,17065 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Martin, Jésus,28324 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Alvarez, Kari, C,11108 | 8124.04 | 0.00 | 3374.99 | 2329.99 | 2419.06 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Chander, Damien,11080 | 8204.02 | 0.00 | 3374.99 | 2359.98 | 2469.05 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 32.27 | 36.43 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 27.28 | 121.42 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 106.96 | 8.99 |
| Lu, Warren, H,28925 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Black, Michele,13995 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Mehta, Regina,17245 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| She, Susan,19956 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Kumar, Chad,11095 | 8158.01 | 0.00 | 3374.99 | 2363.96 | 2419.06 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Wu, Arturo, A,28321 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rubio, Walter, R,25912 | 63.47 | 0.00 | 0.00 | 0.00 | 63.47 |
| Deng, Willie, J,27876 | 1214.85 | 0.00 | 0.00 | 0.00 | 1214.85 |
| Rubio, Natasha, K,13627 | 214.25 | 0.00 | 0.00 | 94.25 | 120.00 |
| Chande, Louis, A,16681 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Patel, Kaitlin, L,16615 | 95.84 | 0.00 | 0.00 | 0.00 | 95.84 |
| Ramos, Albert, E,27716 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Smith, Thomas,17068 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Sai, Abby, L,11101 | 8262.52 | 0.00 | 3399.99 | 2439.99 | 2422.54 |
| Johnsen, Eddie,28935 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Yuan, Jaclyn,24904 | 2199.90 | 0.00 | 0.00 | 2199.90 | 0.00 |
| Moore, Lucas, J,15021 | 38.98 | 0.00 | 0.00 | 29.99 | 8.99 |
| Zhao, Laura, T,24589 | 68.97 | 0.00 | 0.00 | 68.97 | 0.00 |
| Goel, Peter, L,15264 | 38.98 | 0.00 | 0.00 | 8.99 | 29.99 |
| Martinez, Fernando,20454 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Chandra, Cesar, R,20236 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Guo, Margaret,23431 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Martinez, Ethan, C,20260 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Xu, Mindy,20246 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Ramos, Sabrina, L,29082 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Johnston, Tamara, H,18492 | 218.26 | 0.00 | 0.00 | 0.00 | 218.26 |
| Prasad, Brett, A,20262 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Subram, Stefanie,12371 | 214.04 | 0.00 | 0.00 | 0.00 | 214.04 |
| Hernandez, Beth, L,29084 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Becker, Keith, P,27515 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rana, Rachael, A,18270 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 34.89 | 94.46 |
| Zheng, Claudia,18691 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Shen, Cristina,26768 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Patterson, Ashley, R,18736 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Luo, Louis,11465 | 8158.04 | 0.00 | 3399.99 | 2319.99 | 2438.06 |
| Raji, Katrina, M,16517 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 2430.96 | 2384.07 |
| Parker, Gabriel,19606 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Malhotra, Arthur, E,25267 | 25.48 | 0.00 | 0.00 | 25.48 | 0.00 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Serrano, Kristi,20616 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Tang, Bridget,17730 | 4752.23 | 0.00 | 3578.27 | 0.00 | 1173.96 |
| Bailey, Destiny, C,22941 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Mehta, Michele,26143 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Gao, Edwin,25716 | 1302.59 | 0.00 | 699.10 | 0.00 | 603.49 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Xu, Crystal, E,15754 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Carlson, Billy, C,19667 | 150.95 | 0.00 | 0.00 | 0.00 | 150.95 |
| Navarro, Latasha, L,11100 | 8172.51 | 0.00 | 3374.99 | 2399.47 | 2398.05 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Lal, Tracy, W,23086 | 12.94 | 0.00 | 0.00 | 12.94 | 0.00 |
| Cai, Autumn, O,26163 | 123.98 | 0.00 | 0.00 | 123.98 | 0.00 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Hernandez, Darren, A,18709 | 6098.54 | 0.00 | 3578.27 | 2520.27 | 0.00 |
| Moreno, Kathleen, C,15234 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 22.97 | 60.47 |
| Vazquez, Krista,26164 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zheng, Cara, L,27513 | 563.77 | 0.00 | 0.00 | 0.00 | 563.77 |
| Nath, Dale, B,27343 | 132.97 | 0.00 | 0.00 | 0.00 | 132.97 |
| Patel, Ann,21371 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Aaron, C,18695 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Jimenez, Erik, H,21989 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Raji, Christy,15584 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 25.48 | 0.00 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 75.97 | 28.99 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Lal, Leonard,26160 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Suri, Pedro,26422 | 1980.96 | 0.00 | 0.00 | 782.99 | 1197.97 |
| Xu, Willie, C,13160 | 6839.46 | 0.00 | 0.00 | 2071.42 | 4768.04 |
| Henderson, Angela, T,11898 | 8179.03 | 0.00 | 3399.99 | 2394.97 | 2384.07 |
| Zhang, Jon,28111 | 865.31 | 0.00 | 0.00 | 865.31 | 0.00 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Shan, Damien, M,11362 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 0.00 | 2049.10 | 4763.02 |
| Blanco, Jésus, E,20448 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Hernandez, Max,18192 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Guo, Trisha,18253 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
Generated 2025-11-03 08:03:25.548 UTC