[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 311 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mehta, Abby, C,22179 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 2394.97 | 2398.05 |
| Xie, Dawn,21391 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 39.25 | 0.00 |
| Jimenez, Krista,18257 | 115.95 | 0.00 | 0.00 | 0.00 | 115.95 |
| Campbell, Devin,23653 | 3975.03 | 0.00 | 0.00 | 2181.56 | 1793.47 |
| Kumar, Karl, J,14218 | 5651.88 | 0.00 | 0.00 | 2049.10 | 3602.78 |
| Vance, Jillian, D,15230 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Sharma, Andres, C,24230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Blanco, Erik, J,29093 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Shen, Katie, A,20283 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 0.00 | 129.35 |
| Shan, Connor, C,18901 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Carlson, Jose,19954 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Sanders, Kaylee, C,20221 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Blue, Richard,12006 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Rai, Sharon,20225 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Rubio, Larry,14223 | 155.94 | 0.00 | 0.00 | 0.00 | 155.94 |
| Nara, Michele, R,22842 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Subram, Cassandra, M,16618 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 78.98 | 35.23 |
| Jai, Tasha, A,19771 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Sun, Alvin,18252 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ma, Cara,18885 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Liu, Dennis,29062 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Gill, Kellie,17292 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 0.00 | 66.58 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rana, Joe, D,11916 | 8178.51 | 0.00 | 3374.99 | 0.00 | 4803.52 |
| Zhu, Suzanne, E,25112 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Navarro, Theresa,20627 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Chander, Brad, K,21382 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
| Yang, Colleen,22167 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Evans, Adam, H,25820 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Raji, Tammy, K,17071 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Yuan, Warren, P,19091 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Ortega, Jill, A,20239 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Tang, Wayne, S,13090 | 6812.42 | 0.00 | 0.00 | 2049.10 | 4763.32 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Prasad, Clifford,15604 | 66.75 | 0.00 | 0.00 | 0.00 | 66.75 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Romero, Mallory,26434 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liang, Colin,13639 | 188.96 | 0.00 | 0.00 | 0.00 | 188.96 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Garcia, Dominique,16528 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
Generated 2025-12-22 06:45:13.246 UTC