[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 312 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chapman, Jodi, L,22966 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Powell, Amanda,28113 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Xie, Kurt, A,14344 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Diaz, Felicia, J,15026 | 29.98 | 0.00 | 0.00 | 0.00 | 29.98 |
| Shan, Dylan,19677 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Nara, Rafael, J,17052 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Lal, Rafael, W,28945 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Alvarez, Max, M,11986 | 8245.23 | 0.00 | 3399.99 | 0.00 | 4845.24 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Deng, Grant, C,16625 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 0.00 | 831.33 |
| Li, Luis, K,20251 | 59.47 | 0.00 | 0.00 | 0.00 | 59.47 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Adams, Isabella,15715 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Sanz, Diane, M,20153 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 0.00 | 193.97 |
| Yuan, Cassie, J,24453 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 64.97 | 156.94 |
| Xu, Colin, C,29461 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Jai, Kathryn,23546 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 0.00 | 90.95 |
| Suarez, Danny,20995 | 4127.25 | 0.00 | 3578.27 | 0.00 | 548.98 |
| Deng, Johnny,21409 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Jenkins, Noah, A,24379 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 0.00 | 603.49 |
| Yuan, Deborah,12021 | 4043.46 | 0.00 | 3399.99 | 0.00 | 643.47 |
| Luo, Shawn,12246 | 3947.25 | 0.00 | 3374.99 | 0.00 | 572.26 |
| Rubio, Sabrina, A,20984 | 4153.25 | 0.00 | 3578.27 | 0.00 | 574.98 |
| Collins, Andrea,12250 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Morcos, Hany,20821 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Lewis, Kayla,12013 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Vance, Meredith, B,20983 | 4178.73 | 0.00 | 3578.27 | 0.00 | 600.46 |
| Sandberg, Kristine,12241 | 3989.46 | 0.00 | 3399.99 | 0.00 | 589.47 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Johnson, Chloe, L,20617 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Nath, Alvin, R,29301 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 0.00 | 4890.01 |
| Vazquez, Randall, Z,21186 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Garcia, Harold, K,14087 | 341.97 | 0.00 | 0.00 | 0.00 | 341.97 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Hernandez, Logan,12350 | 6791.75 | 0.00 | 2071.42 | 0.00 | 4720.33 |
| Griffin, Olivia,21208 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 0.00 | 57.59 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Johnsen, Ross,19618 | 119.45 | 0.00 | 0.00 | 0.00 | 119.45 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Natsuhara, Tony,23097 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Prasad, Harold,19608 | 68.45 | 0.00 | 0.00 | 0.00 | 68.45 |
| Zheng, Arturo, C,11467 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Moreno, Dana, D,15033 | 3797.40 | 0.00 | 0.00 | 2071.42 | 1725.98 |
| Yang, Stacey,14215 | 5665.89 | 0.00 | 0.00 | 2049.10 | 3616.79 |
| Serrano, Francis, R,23547 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 58.47 | 110.96 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| Lal, Clarence, L,24470 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 0.00 | 2071.42 | 4796.02 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Kumar, Warren, A,24003 | 2806.53 | 0.00 | 0.00 | 2181.56 | 624.97 |
| Hernandez, Kristine,14286 | 5234.40 | 0.00 | 0.00 | 2049.10 | 3185.30 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Zheng, Erica, K,23643 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 2071.42 | 3581.10 |
| Vance, Denise, L,21205 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Gutierrez, Pedro, S,15224 | 71.92 | 0.00 | 0.00 | 0.00 | 71.92 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Gray, Morgan,28307 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 0.00 | 2071.42 | 4734.05 |
| Blanco, Jimmy, V,14013 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Simmons, Jacqueline, W,13137 | 177.94 | 0.00 | 0.00 | 0.00 | 177.94 |
| Hernandez, Mallory,29091 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Yuan, Lacey, W,12349 | 6772.14 | 0.00 | 2049.10 | 0.00 | 4723.04 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Munoz, Casey, W,12570 | 2654.06 | 0.00 | 2049.10 | 0.00 | 604.96 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Chander, Karla,23648 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Gutierrez, Meghan, E,26021 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Lopez, Barry, R,26020 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Xu, Clarence,21877 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Gill, Roy,29465 | 791.32 | 0.00 | 0.00 | 0.00 | 791.32 |
| Xu, Rafael, N,21195 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Nath, Cassie,24606 | 2155.92 | 0.00 | 1000.44 | 1155.48 | 0.00 |
| Fernandez, Rachael, M,23993 | 3072.32 | 0.00 | 0.00 | 2443.35 | 628.97 |
| Moreno, Beth,21980 | 4334.61 | 0.00 | 0.00 | 2443.35 | 1891.26 |
| Subram, Kristi, N,15025 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
Generated 2025-12-21 15:25:13.177 UTC