[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2500 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sai, Kari, E,14231 | 83.97 | 0.00 | 0.00 | 24.99 | 58.98 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 0.00 | 4856.99 |
| Goel, Bethany,27511 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Black, Peter, E,21213 | 64.26 | 0.00 | 0.00 | 0.00 | 64.26 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Gutierrez, Cheryl, O,25213 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Fernandez, Emmanuel,28955 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Hu, Ramon,23439 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| Moore, Michael,17247 | 4432.72 | 0.00 | 3578.27 | 0.00 | 854.45 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Sharma, Sharon, T,25294 | 1882.57 | 699.10 | 0.00 | 0.00 | 1183.47 |
| Shen, Alison, A,16614 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Sanchez, Henry,26968 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Liu, Darryl,19947 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Perry, Madison, R,23308 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Raman, Virginia,26159 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 564.48 | 0.00 |
| Serrano, Stacy,24613 | 2148.21 | 0.00 | 0.00 | 2148.21 | 0.00 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Tang, Barbara,27711 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 2049.10 | 1760.47 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 0.00 | 71.57 |
| Srini, Beth, A,25913 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Moreno, Naomi, C,15601 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
| Raje, Marshall, J,19267 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Alvarez, Jessie,14324 | 5121.43 | 0.00 | 0.00 | 2049.10 | 3072.33 |
| Zhou, Warren,19791 | 6058.21 | 0.00 | 3578.27 | 0.00 | 2479.94 |
| Gutierrez, Jaime, A,25227 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Vazquez, Jerome,23116 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Srini, Joe,22180 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Flores, Connor,15755 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Gomez, Andy,18721 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Romero, Jimmy,27704 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Lu, Warren, H,28925 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Alonso, Renee,24166 | 2789.52 | 0.00 | 0.00 | 2181.56 | 607.96 |
| Lu, Candice, I,21204 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Lu, Tiffany,22843 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Malhotra, Darren, L,20245 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Li, Lisa, J,24600 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Allen, Mary,21203 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Garcia, Carolyn,20999 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 0.00 | 116.93 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Ward, Katelyn,20258 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Lee, Austin,26151 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chavez, Karla, K,16704 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Lin, Heather, L,15718 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Rivera, Mariah,20261 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Suarez, Ricky,29066 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 0.00 | 2181.56 | 2482.23 |
| Serrano, Max, E,12010 | 8203.50 | 0.00 | 3374.99 | 0.00 | 4828.51 |
| Deng, Sheena,19099 | 6038.56 | 0.00 | 3578.27 | 0.00 | 2460.29 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 0.00 | 4789.02 |
| Xu, Edwin, J,25272 | 1873.58 | 0.00 | 699.10 | 0.00 | 1174.48 |
| Yuan, Julie,22959 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gill, Jay,27975 | 83.47 | 0.00 | 0.00 | 0.00 | 83.47 |
| Vazquez, Erika, S,22974 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Suarez, Meredith,15032 | 3800.08 | 0.00 | 0.00 | 2049.10 | 1750.98 |
| Lal, Colin, M,16640 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sun, Shannon,12007 | 7023.78 | 0.00 | 3399.99 | 0.00 | 3623.79 |
| Wang, Jon, A,26191 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Sai, Summer, S,22855 | 70.96 | 0.00 | 0.00 | 0.00 | 70.96 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Perez, Carmen, C,13139 | 6854.45 | 0.00 | 0.00 | 2071.42 | 4783.03 |
| Ashe, Katie, Z,26770 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xu, Julie,18301 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Liu, Brittney, M,15804 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Carlson, Marc, W,17501 | 141.98 | 0.00 | 0.00 | 0.00 | 141.98 |
| Carlson, Jose,19954 | 74.45 | 0.00 | 0.00 | 60.47 | 13.98 |
| Cox, Nicole, V,22950 | 3917.54 | 0.00 | 0.00 | 3917.54 | 0.00 |
| Rana, Joe, D,11916 | 8178.51 | 0.00 | 3374.99 | 0.00 | 4803.52 |
| She, Kelli, J,24889 | 2269.91 | 0.00 | 0.00 | 1000.44 | 1269.47 |
| Schmidt, Pamela, I,24375 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Lal, Bradley,13156 | 2663.69 | 0.00 | 0.00 | 2071.42 | 592.27 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Nara, Derek, A,26139 | 34.47 | 0.00 | 0.00 | 0.00 | 34.47 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Munoz, Alfredo, C,23314 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 0.00 | 2071.42 | 4775.50 |
| Perez, Patricia,25022 | 1564.92 | 0.00 | 0.00 | 1000.44 | 564.48 |
| Raman, Abby, T,15122 | 5193.72 | 0.00 | 0.00 | 2071.42 | 3122.30 |
| Gray, Jeremiah,23331 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Lal, Gabriel,27473 | 1398.46 | 0.00 | 0.00 | 782.99 | 615.47 |
| Mehta, Evelyn, S,20420 | 4132.24 | 0.00 | 3578.27 | 0.00 | 553.97 |
| Pal, Peter, K,22848 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Lopez, Sergio, L,15123 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Zhou, Louis, C,17912 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Alexander, Gabriel, C,14073 | 156.84 | 0.00 | 0.00 | 0.00 | 156.84 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Subram, Stefanie,12371 | 214.04 | 0.00 | 0.00 | 0.00 | 214.04 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
Generated 2025-12-18 00:04:26.022 UTC