[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Ashe, Orlando, I,11897 | 8203.02 | 0.00 | 3399.99 | 2329.98 | 2473.05 |
| Alvarez, Philip, A,11123 | 45.88 | 0.00 | 0.00 | 37.93 | 7.95 |
| Alvarez, Randall,26750 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 782.99 | 0.00 | 1142.42 |
| Sanders, Charles, E,21967 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Li, Alejandro, A,27519 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Hernandez, Frank, G,22198 | 4661.50 | 0.00 | 2181.56 | 0.00 | 2479.94 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 94.25 | 24.49 |
| Chen, Aimee,26591 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Moreno, Marc,13024 | 2665.06 | 0.00 | 2049.10 | 0.00 | 615.96 |
| Liang, Christy, I,21239 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Chandra, Cesar, R,20236 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 4489.09 | 2473.05 |
| Luo, Darrell, J,21187 | 32.28 | 0.00 | 0.00 | 32.28 | 0.00 |
| Martin, Arthur, L,28943 | 49.97 | 0.00 | 0.00 | 49.97 | 0.00 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 4346.38 | 2419.06 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 17.94 | 24.99 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 34.99 | 54.25 |
| Jai, Derek, E,13613 | 105.22 | 0.00 | 0.00 | 105.22 | 0.00 |
| Rana, Rachael, A,18270 | 94.47 | 0.00 | 0.00 | 8.99 | 85.48 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 86.27 | 0.00 |
| Sharma, Dustin, M,18484 | 6093.20 | 3578.27 | 0.00 | 2514.93 | 0.00 |
| Chander, Alison,18249 | 6044.59 | 3578.27 | 0.00 | 2466.32 | 0.00 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 564.48 | 0.00 |
| Zeng, Dennis, S,13050 | 5651.25 | 0.00 | 2071.42 | 1249.84 | 2329.99 |
| Hill, Luis,27500 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Lopez, Joe, L,27512 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 28.98 | 49.99 |
| Lu, Jamie, M,23646 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 79.69 | 0.00 |
| Raji, Kelli, G,13123 | 6765.44 | 0.00 | 2049.10 | 2297.28 | 2419.06 |
| Raman, Michele,17233 | 4347.76 | 3578.27 | 0.00 | 769.49 | 0.00 |
| Rubio, Max, L,19578 | 91.26 | 0.00 | 0.00 | 37.27 | 53.99 |
| Bailey, Destiny, C,22941 | 58.98 | 0.00 | 0.00 | 58.98 | 0.00 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Shen, Lindsey,26560 | 1396.44 | 0.00 | 782.99 | 0.00 | 613.45 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 54.47 | 123.98 |
| Green, Kyle,28328 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Suri, Adriana,18463 | 4726.04 | 3578.27 | 0.00 | 0.00 | 1147.77 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Ms., Robinson, Rebecca, A.,11913 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Serrano, Audrey,18337 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Navarro, Kristine, B,25566 | 1253.07 | 699.10 | 0.00 | 0.00 | 553.97 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Xie, Karla,18201 | 4157.73 | 3578.27 | 0.00 | 0.00 | 579.46 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Mr., Short, Carlos, M.,25139 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Huang, Tamara, E,14053 | 86.26 | 0.00 | 0.00 | 86.26 | 0.00 |
| Jai, Tasha, A,19771 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Zhu, Jorge,26141 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Reed, Riley, A,20157 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Zhang, Amy,18307 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 110.46 | 0.00 |
| Martin, Diane,13958 | 6838.64 | 0.00 | 2049.10 | 0.00 | 4789.54 |
| Powell, Trevor, C,26922 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Vazquez, Jonathon,17906 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Perez, Kyle, J,16180 | 4386.37 | 0.00 | 0.00 | 2049.10 | 2337.27 |
| Prasad, Jarrod,11359 | 4960.07 | 3374.99 | 0.00 | 0.00 | 1585.08 |
| Sharma, Tracy,17731 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 2181.56 | 0.00 | 2502.83 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Sutton, Jaime, L,16630 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 53.99 | 119.94 |
| Suri, Rachael, J,18279 | 162.02 | 0.00 | 0.00 | 0.00 | 162.02 |
| Alexander, Gail, C,14682 | 138.45 | 0.00 | 0.00 | 88.46 | 49.99 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Butler, Hannah, R,13111 | 5707.20 | 0.00 | 2071.42 | 0.00 | 3635.78 |
| Martinez, Jay,24592 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 53.99 | 37.27 |
| Powell, Adam,23423 | 3936.54 | 0.00 | 0.00 | 3936.54 | 0.00 |
| Zhang, Roger,12690 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Yang, Colin, J,20612 | 6060.50 | 0.00 | 3578.27 | 2482.23 | 0.00 |
| Raman, Sergio,27866 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2813.77 | 2309.97 |
| Suri, Kristopher, M,22849 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Navarro, Jill,22003 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Hernandez, Julio, J,23078 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 58.98 | 27.28 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 2049.10 | 2343.96 | 2419.06 |
| Munoz, Tanya,23436 | 3950.52 | 0.00 | 0.00 | 3950.52 | 0.00 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 24.99 | 103.47 |
| King, Evan,16637 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Hernandez, Krista, J,26918 | 1399.94 | 0.00 | 0.00 | 782.99 | 616.95 |
| Dominguez, Robin,16685 | 4183.23 | 3578.27 | 0.00 | 0.00 | 604.96 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Zheng, Rosa, G,16629 | 5933.26 | 3578.27 | 0.00 | 0.00 | 2354.99 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 554.97 | 742.35 |
| Zeng, Wesley,20460 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Guo, Krystal, S,17381 | 188.93 | 0.00 | 0.00 | 188.93 | 0.00 |
| Jai, Tara, E,27363 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 120.00 | 21.98 |
| Xu, Kelvin,18305 | 160.55 | 0.00 | 0.00 | 36.59 | 123.96 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 77.92 | 37.93 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 53.99 | 28.98 |
| Navarro, Bruce, D,17353 | 6035.60 | 3578.27 | 0.00 | 2457.33 | 0.00 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 4476.05 | 2413.06 |
| Gomez, Kendra, J,23320 | 2730.54 | 0.00 | 0.00 | 2730.54 | 0.00 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| 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 |
| Zhang, Kristen,27484 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Lal, Nina, L,14263 | 5647.93 | 0.00 | 0.00 | 2049.10 | 3598.83 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Muñoz, Pedro, A,23433 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 2049.10 | 0.00 | 4744.05 |
| Raje, Christy,23100 | 3007.12 | 0.00 | 2443.35 | 0.00 | 563.77 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
Generated 2026-07-21 13:33:39.274 UTC