[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 |
|---|---|---|---|---|---|
| Luo, Devon, D,22850 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Ruiz, Carolyn, M,27863 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Sai, Levi,16349 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Ross, Julian,11363 | 5035.81 | 3399.99 | 0.00 | 0.00 | 1635.82 |
| Chen, Jon,26920 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 3298.94 | 2354.98 |
| Kapoor, Abby, J,29054 | 751.34 | 0.00 | 0.00 | 751.34 | 0.00 |
| Liang, Amy,16164 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Flores, Antonio, D,14259 | 3630.93 | 0.00 | 0.00 | 2888.58 | 742.35 |
| Goel, Karla, L,11146 | 112.93 | 0.00 | 0.00 | 53.95 | 58.98 |
| Zhao, Jamie,16179 | 72.16 | 0.00 | 0.00 | 0.00 | 72.16 |
| Gutierrez, Dana,20254 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| King, Kevin, W,21402 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 79.69 | 0.00 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Zeng, Claudia, M,16696 | 4506.76 | 3578.27 | 0.00 | 928.49 | 0.00 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 2071.42 | 2394.97 | 2428.05 |
| Ruiz, Marie, J,27498 | 1350.75 | 0.00 | 0.00 | 1350.75 | 0.00 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 92.97 | 0.00 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 21.98 | 8.99 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Bailey, Melissa, C,19572 | 82.25 | 0.00 | 0.00 | 82.25 | 0.00 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 2520.27 | 0.00 |
| Lal, Alisha, C,21872 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Xie, Lindsey, M,25132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Raji, Lacey, E,16341 | 88.25 | 0.00 | 0.00 | 0.00 | 88.25 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Hu, Amy,14320 | 261.95 | 0.00 | 0.00 | 0.00 | 261.95 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Wu, Glenn, R,29343 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 22.97 | 21.98 |
| He, Karen, C,27861 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Johnsen, Mario, W,26587 | 1920.42 | 0.00 | 782.99 | 0.00 | 1137.43 |
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Arthur, Joel,27701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sharma, Jerry, C,13651 | 6812.12 | 0.00 | 2049.10 | 2343.96 | 2419.06 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Chandra, Monica, H,18898 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Ruiz, Shannon,20822 | 4134.53 | 0.00 | 3578.27 | 556.26 | 0.00 |
| Jimenez, Jimmy,27365 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Perez, Johnathan, D,20426 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 539.99 | 0.00 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 549.98 | 0.00 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 62.27 | 0.00 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 27.28 | 39.47 |
| Cooper, Katherine, R,14314 | 122.95 | 0.00 | 0.00 | 58.98 | 63.97 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 34.99 | 24.99 |
| Yang, Valerie, L,27361 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Shan, Drew,23659 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Dominguez, Walter,12576 | 2653.07 | 0.00 | 2049.10 | 0.00 | 603.97 |
| Malhotra, Marco, L,29459 | 805.33 | 0.00 | 0.00 | 0.00 | 805.33 |
| Alvarez, Adrienne, L,17067 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 2049.10 | 0.00 | 4744.05 |
| Munoz, Meredith,13957 | 5645.24 | 0.00 | 0.00 | 2071.42 | 3573.82 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 2334.98 | 2461.55 |
| Hernandez, Hailey, A,18727 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Subram, Ivan, A,26147 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 35.72 | 0.00 |
| Lopez, Francisco, L,18714 | 24.27 | 0.00 | 0.00 | 24.27 | 0.00 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2964.89 | 751.34 |
| Ramos, Audrey,11976 | 8087.31 | 0.00 | 3374.99 | 2319.26 | 2393.06 |
| Blanco, Lori, A,15735 | 116.25 | 0.00 | 0.00 | 31.27 | 84.98 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 556.93 | 0.00 |
| Martin, Deanna,13091 | 6864.95 | 0.00 | 2071.42 | 2349.98 | 2443.55 |
| King, Jesse, J,14665 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Pal, Mindy,19097 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
| Gao, Jake, A,19955 | 173.45 | 0.00 | 0.00 | 30.48 | 142.97 |
| Zhu, Damien, M,15822 | 43.21 | 0.00 | 0.00 | 14.23 | 28.98 |
| Nath, Tommy, B,28937 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Sai, Lydia, L,13968 | 5181.70 | 0.00 | 0.00 | 2862.74 | 2318.96 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 554.97 | 742.35 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 4346.38 | 2419.06 |
| Dominguez, Roberto, A,26917 | 1339.25 | 0.00 | 0.00 | 782.99 | 556.26 |
| Alonso, Diana, L,24590 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 6.28 | 31.27 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 21.98 | 10.24 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 67.58 | 0.00 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 8.99 | 63.97 |
| Mehta, Edgar,11761 | 8149.49 | 0.00 | 3399.99 | 2356.44 | 2393.06 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 3399.99 | 0.00 | 2318.96 | 2418.05 |
| Tang, Leonard, L,28109 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 845.31 | 0.00 |
| Gutierrez, Jay, C,13155 | 226.95 | 0.00 | 0.00 | 217.96 | 8.99 |
| Lu, Ramon, B,16738 | 44.95 | 0.00 | 0.00 | 44.95 | 0.00 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 1223.84 | 2294.99 |
| Ms., Roy, Lisa, K.,21403 | 4895.69 | 0.00 | 2443.35 | 0.00 | 2452.34 |
| Alvarez, Francis,21552 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gomez, Carrie,22965 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Madan, Cory,26154 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Nath, Louis, C,25830 | 1833.57 | 0.00 | 699.10 | 0.00 | 1134.47 |
| Yuan, Darrell,18271 | 119.95 | 0.00 | 0.00 | 8.99 | 110.96 |
| Van, Brett,26166 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2791.45 | 2349.98 |
| Chander, Damien,11080 | 8204.02 | 3374.99 | 0.00 | 4829.03 | 0.00 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 7.95 | 50.21 |
| Shan, Brad, H,19605 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Ye, Christy,14219 | 5744.22 | 0.00 | 0.00 | 3286.27 | 2457.95 |
| Lu, Candice, I,21204 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Malhotra, Ruben, M,17074 | 90.25 | 0.00 | 0.00 | 90.25 | 0.00 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 34.99 | 28.98 |
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 2369.96 | 2419.06 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 2319.99 | 2428.05 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 9.99 | 22.97 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 106.96 | 8.99 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 112.73 | 0.00 |
| Hernandez, Raquel, W,13997 | 4586.35 | 0.00 | 0.00 | 2071.42 | 2514.93 |
| Alvarez, Kendra, R,15267 | 2853.58 | 0.00 | 0.00 | 2049.10 | 804.48 |
| Rai, Raul, R,15133 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Dominguez, Darren, M,13966 | 6842.12 | 0.00 | 0.00 | 2049.10 | 4793.02 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
Generated 2026-07-21 14:27:31.006 UTC