[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 252 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Zhang, Willie, T,16023 | 166.89 | 0.00 | 0.00 | 0.00 | 166.89 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Ruiz, Hector,27592 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gonzalez, Tabitha, A,26136 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Serrano, Neil, L,17076 | 103.46 | 0.00 | 0.00 | 0.00 | 103.46 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Romero, Rodney,14521 | 117.96 | 0.00 | 0.00 | 0.00 | 117.96 |
| Bell, Jessica,22178 | 4233.32 | 0.00 | 0.00 | 2443.35 | 1789.97 |
| Cai, Tiffany,18204 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Ye, Damien, M,13620 | 6848.07 | 0.00 | 0.00 | 2049.10 | 4798.97 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Xie, Brendan,13018 | 2642.38 | 0.00 | 0.00 | 2071.42 | 570.96 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Powell, Jeremy,11048 | 6498.24 | 0.00 | 3374.99 | 0.00 | 3123.25 |
| Malhotra, Cynthia,11358 | 5034.78 | 0.00 | 3374.99 | 0.00 | 1659.79 |
| Morgan, Mackenzie, E,16162 | 185.04 | 0.00 | 0.00 | 0.00 | 185.04 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Nara, Latoya, J,18208 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| King, Maria, E,28202 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Alvarez, Kari, C,11108 | 8124.04 | 0.00 | 3374.99 | 2329.99 | 2419.06 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 2294.99 | 2419.06 |
| Anderson, Blake,11076 | 8159.04 | 0.00 | 3399.99 | 2374.98 | 2384.07 |
| Andersen, Karl, M,23105 | 3361.53 | 0.00 | 0.00 | 3361.53 | 0.00 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Verhoff, Rob,11008 | 8106.31 | 3374.99 | 0.00 | 2312.26 | 2419.06 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Ma, Brittney,12584 | 2633.39 | 0.00 | 0.00 | 2071.42 | 561.97 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Morgan, Natalie,15149 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Mehta, Regina,17245 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Roberts, Jennifer,11447 | 8078.02 | 0.00 | 3374.99 | 2309.97 | 2393.06 |
| Gao, Edwin,25716 | 1302.59 | 0.00 | 699.10 | 0.00 | 603.49 |
| Rai, Johnny, A,13135 | 6773.14 | 0.00 | 0.00 | 2049.10 | 4724.04 |
| Chande, Jerry,18331 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Goel, Bradley,15803 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Ramos, Joy,13129 | 6823.15 | 0.00 | 0.00 | 2049.10 | 4774.05 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 0.00 | 294.94 |
| Diaz, Ricky, E,18335 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Green, Devin, J,26440 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Liu, Jaclyn,12996 | 6808.15 | 0.00 | 0.00 | 2049.10 | 4759.05 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Huang, Amy, C,12244 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Powell, Thomas, R,18218 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Alvarez, Linda,14047 | 5643.54 | 0.00 | 0.00 | 3321.26 | 2322.28 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Sanz, Ross,11455 | 8142.03 | 0.00 | 3374.99 | 2319.99 | 2447.05 |
| Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Kapoor, Ruben, D,11109 | 8245.01 | 0.00 | 3374.99 | 2476.96 | 2393.06 |
| Sara, Ruben, A,19566 | 164.91 | 0.00 | 0.00 | 0.00 | 164.91 |
| Navarro, Casey,19795 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Saunders, Jillian,21178 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Schmidt, Monica,12012 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Rivera, Nathaniel, M,14051 | 5606.91 | 0.00 | 0.00 | 3286.92 | 2319.99 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Gao, Trisha, A,28953 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Luo, Colin, L,21210 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Cai, Autumn, O,26163 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Chande, Carl,18932 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Hernandez, Isaac,25813 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Powell, Kaitlyn,19598 | 5310.53 | 0.00 | 3578.27 | 0.00 | 1732.26 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Becker, Latoya, W,17330 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Kristy,16682 | 66.58 | 0.00 | 0.00 | 0.00 | 66.58 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Carlson, Mathew, A,23012 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Stone, Brenda, J,12697 | 296.19 | 0.00 | 0.00 | 0.00 | 296.19 |
| Li, Aimee,17915 | 4792.73 | 0.00 | 3578.27 | 0.00 | 1214.46 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Pal, Sheena, D,21197 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Jimenez, Erik, H,21989 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Liang, Barbara, T,22953 | 3899.49 | 0.00 | 0.00 | 2181.56 | 1717.93 |
| Shen, Russell, M,11150 | 192.42 | 0.00 | 0.00 | 0.00 | 192.42 |
| Green, Alex, K,20317 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Ramos, Jessie, R,11764 | 8129.02 | 0.00 | 3399.99 | 0.00 | 4729.03 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 0.00 | 2492.32 |
| Chavez, Jodi, A,18909 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Blanco, Monique, W,14103 | 3612.22 | 0.00 | 0.00 | 2071.42 | 1540.80 |
| Miller, Zachary, M,15169 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Tang, Terrence, R,17303 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Carson, Kelvin, A,11995 | 8249.01 | 0.00 | 3399.99 | 0.00 | 4849.02 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Navarro, Monique, R,15240 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Chande, Tonya,11992 | 8123.03 | 0.00 | 3399.99 | 0.00 | 4723.04 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Gonzalez, Cynthia,15787 | 167.93 | 0.00 | 0.00 | 0.00 | 167.93 |
| Xu, Alison,14227 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Moyer, Meghan,21220 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Torres, Naomi, J,14061 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Blanco, Wendy, J,19604 | 171.73 | 0.00 | 0.00 | 0.00 | 171.73 |
| Raje, Alison, J,12345 | 64.71 | 0.00 | 0.00 | 0.00 | 64.71 |
| Carter, Amber, E,16679 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Liang, Candice,22208 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Wang, Jaclyn, M,17063 | 100.25 | 0.00 | 0.00 | 0.00 | 100.25 |
| Moreno, Melody, R,11760 | 274.92 | 0.00 | 0.00 | 0.00 | 274.92 |
Generated 2025-12-22 02:33:17.878 UTC