[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1124 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Sara, George,24247 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Jai, Warren, S,16483 | 4118.26 | 3578.27 | 0.00 | 0.00 | 539.99 |
| She, Candice,29178 | 2452.04 | 0.00 | 0.00 | 0.00 | 2452.04 |
| Yuan, Lacey, W,12349 | 6772.14 | 0.00 | 2049.10 | 0.00 | 4723.04 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 0.00 | 2049.10 | 3534.84 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Yuan, Ricardo,16674 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Alexander, Olivia, L,14667 | 5295.41 | 0.00 | 0.00 | 2049.10 | 3246.31 |
| Alonso, Jimmy, T,18280 | 126.56 | 0.00 | 0.00 | 0.00 | 126.56 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Ramos, Carolyn,17926 | 4715.70 | 0.00 | 3578.27 | 0.00 | 1137.43 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Sanz, Julio, H,21404 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| She, Roger, L,15724 | 4359.07 | 0.00 | 0.00 | 2049.10 | 2309.97 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Rai, Tasha, L,24301 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Hernandez, Monique, J,15138 | 123.45 | 0.00 | 0.00 | 34.99 | 88.46 |
| Xu, Kelvin, K,21222 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 58.47 | 110.96 |
| Raji, Wayne, A,26161 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Gomez, Gary,15640 | 34.57 | 0.00 | 0.00 | 2.29 | 32.28 |
| She, Corey, T,21214 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Suri, Molly,17503 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Mehta, Erick, E,14123 | 61.58 | 0.00 | 0.00 | 0.00 | 61.58 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Lu, Christy,17062 | 91.26 | 0.00 | 0.00 | 53.99 | 37.27 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 0.00 | 90.75 |
| Chandra, Virginia, M,27588 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Goel, Alicia, H,20423 | 4177.74 | 0.00 | 3578.27 | 0.00 | 599.47 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Ms., Rousey, Linda, R.,21279 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Shen, Cristina,26768 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Gutierrez, Frank, G,22846 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Moreno, Krista, J,16745 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Raji, Brendan,13103 | 6842.60 | 0.00 | 0.00 | 2049.10 | 4793.50 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Ward, Shelby,26132 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 0.00 | 4815.03 |
| Martin, Briana, L,15213 | 2818.59 | 0.00 | 0.00 | 2049.10 | 769.49 |
| Zhou, Rafael, A,24494 | 9.99 | 0.00 | 0.00 | 9.99 | 0.00 |
| Luo, Ashlee,23534 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Carlson, Marie,29311 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Yang, Todd, J,19094 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Goel, Yolanda, M,26435 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zeng, Ramon,27979 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Garcia, Roy, H,15585 | 4367.02 | 0.00 | 0.00 | 2049.10 | 2317.92 |
| Martin, Gerald, K,17284 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Yang, Hunter, E,20237 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Alvarez, Philip, A,11123 | 45.88 | 0.00 | 0.00 | 0.00 | 45.88 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Andersen, Willie, M,27970 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Raji, Jaclyn,18289 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Turner, Lucas,22948 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 0.00 | 2071.42 | 4823.02 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Shen, Priscilla, A,28215 | 589.96 | 0.00 | 0.00 | 0.00 | 589.96 |
| Patel, Bryant, L,27969 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Parker, Mason, W,25923 | 6.28 | 0.00 | 0.00 | 6.28 | 0.00 |
| Ramos, Eddie, T,13954 | 128.46 | 0.00 | 0.00 | 0.00 | 128.46 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Huang, Sandra, C,16523 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Pal, Derek,24591 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
| Nath, Kara, S,21177 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 0.00 | 3175.80 |
| Rubio, Mallory, S,11098 | 88.96 | 0.00 | 0.00 | 0.00 | 88.96 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Evans, Mason,15439 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Martin, Ethan, M,13998 | 245.25 | 0.00 | 0.00 | 97.97 | 147.28 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Lopez, Barry, R,26020 | 1932.46 | 0.00 | 782.99 | 0.00 | 1149.47 |
| Xu, Casey, J,13158 | 221.91 | 0.00 | 0.00 | 0.00 | 221.91 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Xie, Karla,18201 | 4157.73 | 0.00 | 3578.27 | 0.00 | 579.46 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Dominguez, Wendy,11035 | 6451.31 | 0.00 | 3374.99 | 0.00 | 3076.32 |
| Subram, Ross, L,23085 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Liang, Steve,14317 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| She, Alvin, E,16657 | 5900.55 | 0.00 | 3578.27 | 0.00 | 2322.28 |
| Ramos, Francis,16345 | 4173.24 | 3578.27 | 0.00 | 0.00 | 594.97 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 0.00 | 114.21 |
| Ms., Schultz, Barbara, R.,15811 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| 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 | 0.00 | 86.26 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 0.00 | 2181.56 | 2452.34 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Blanco, Lee, M,16660 | 5898.26 | 0.00 | 3578.27 | 0.00 | 2319.99 |
| Serrano, Danny,24381 | 3970.52 | 0.00 | 0.00 | 2181.56 | 1788.96 |
| Zhu, Jorge,26141 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Suarez, Alberto, G,18719 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Schmidt, Deanna, H,25936 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
Generated 2025-12-24 08:16:03.778 UTC