[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 124 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gonzalez, Marco,27598 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Chen, Autumn, I,21408 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Zheng, Jamie, L,22156 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Gary,27482 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Zeng, Colleen, L,28304 | 91.97 | 0.00 | 0.00 | 0.00 | 91.97 |
| Kumar, Tommy,17297 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Shen, Bridget,17237 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Zhao, Jorge,16711 | 132.95 | 0.00 | 0.00 | 0.00 | 132.95 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Ramos, Danny,23121 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Suarez, Jacquelyn, C,11010 | 8088.04 | 3399.99 | 0.00 | 2294.99 | 2393.06 |
| Prasad, Edgar, E,17306 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Sara, Cesar, C,22172 | 2932.30 | 0.00 | 0.00 | 2181.56 | 750.74 |
| Li, Vincent, D,21207 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Rodriguez, Wyatt, D,21218 | 4661.50 | 0.00 | 0.00 | 2181.56 | 2479.94 |
| Lu, Martha, R,21255 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Black, Tracy, B,24903 | 2164.91 | 0.00 | 0.00 | 1000.44 | 1164.47 |
| Jiménez, Deanna,28115 | 562.96 | 0.00 | 0.00 | 0.00 | 562.96 |
| Young, Marcus, A,18494 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Anderson, Emily, M,25220 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Parker, Evan, R,18729 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 0.00 | 2049.10 | 3592.80 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Ruiz, Kristine, J,24607 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Sheena,23312 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Chen, Randy,13004 | 190.27 | 0.00 | 0.00 | 0.00 | 190.27 |
| Madan, Stanley,19602 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Ward, Brooke,13007 | 5671.24 | 0.00 | 0.00 | 2071.42 | 3599.82 |
| Sun, Micah,24887 | 2218.90 | 0.00 | 0.00 | 1000.44 | 1218.46 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Andersen, Colin,25053 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 0.00 | 227.96 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 0.00 | 61.53 |
| Kapoor, Brandy, I,15236 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Xu, Lindsey,15583 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Mehta, Tina, C,11444 | 8136.02 | 0.00 | 3374.99 | 2376.96 | 2384.07 |
| Clark, Sydney,16610 | 67.58 | 0.00 | 0.00 | 0.00 | 67.58 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Rubio, Kathleen, A,20820 | 4143.74 | 0.00 | 3578.27 | 0.00 | 565.47 |
| Sharma, Clayton, D,12240 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 0.00 | 2443.35 | 607.96 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Vazquez, Theresa, F,22581 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
| Coleman, Nicole, A,21558 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Chander, Andres, E,29460 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Rai, Willie,14673 | 5117.75 | 0.00 | 0.00 | 2071.42 | 3046.33 |
| Lal, Terry,18277 | 6070.59 | 0.00 | 3578.27 | 0.00 | 2492.32 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Hernandez, Danny,27146 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Liang, Jenny, S,27351 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Wang, Alejandro,17310 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Weber, Ivan,28317 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Pais, Wilson, C,13038 | 5581.26 | 0.00 | 0.00 | 2071.42 | 3509.84 |
| Subram, Roy,21896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Madan, Kristopher, A,25238 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Malhotra, Joel, E,16343 | 58.25 | 0.00 | 0.00 | 0.00 | 58.25 |
| Xylaras, Ioannis,20215 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Ma, Amy, E,17309 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Gonzalez, Carolyn, H,22407 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Butler, Destiny,27865 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 0.00 | 4748.04 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 0.00 | 4693.04 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Pal, Wayne,19764 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Chander, Clarence, E,13982 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Wu, Brittney,23418 | 3400.02 | 0.00 | 0.00 | 2181.56 | 1218.46 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 0.00 | 148.70 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Powell, Rachel,20818 | 4230.73 | 0.00 | 3578.27 | 0.00 | 652.46 |
| Brown, Kaitlyn,29120 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Sanz, Lance,22573 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Ye, Alejandro, W,15029 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Yuan, Marshall, P,19978 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Srini, Carolyn, S,27371 | 1350.75 | 0.00 | 0.00 | 782.99 | 567.76 |
| Chande, Melvin, R,11460 | 8137.52 | 0.00 | 3399.99 | 0.00 | 4737.53 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Malhotra, Phillip, J,21977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Adams, Savannah,23536 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shan, Franklin, C,27718 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Yang, Martha, G,22210 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 0.00 | 1179.97 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2049.10 | 1590.82 |
| Mr., Smith, Leonard, J.,27972 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Yang, Alan, L,15605 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Martin, Briana, L,15213 | 2818.59 | 0.00 | 0.00 | 2049.10 | 769.49 |
| Suri, Lydia,13126 | 6815.08 | 0.00 | 0.00 | 2049.10 | 4765.98 |
Generated 2025-12-21 15:43:38.977 UTC