[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 92 > < TAKE 120 >
120 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alvarez, Philip, A,11123 | 45.88 | 0.00 | 0.00 | 0.00 | 45.88 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Lee, Grace, J,28318 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Sai, Cassandra, R,28110 | 845.31 | 0.00 | 0.00 | 0.00 | 845.31 |
| Raman, Mayra, P,20990 | 4196.22 | 0.00 | 3578.27 | 0.00 | 617.95 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 49.97 | 59.91 |
| Ms., Sandidge, Mary, R.,14016 | 121.06 | 0.00 | 0.00 | 0.00 | 121.06 |
| Malhotra, Meredith,29314 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Ruiz, Natasha,21994 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Madan, Roy,15716 | 4467.06 | 0.00 | 0.00 | 2049.10 | 2417.96 |
| Ortega, Tyrone, H,12583 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
| Patel, Whitney, F,24468 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Patel, Abby,16029 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Raji, Derek, D,19591 | 63.42 | 0.00 | 0.00 | 0.00 | 63.42 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Rodriguez, Monica, J,28951 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Foster, Hunter, A,20269 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Liang, Brittney, R,26182 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Shan, Kristin,23416 | 3598.83 | 0.00 | 0.00 | 2443.35 | 1155.48 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Zhu, Gilbert,11921 | 63.24 | 0.00 | 0.00 | 0.00 | 63.24 |
| Foster, Aidan,26445 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Ramirez, Isaiah,11905 | 8155.98 | 0.00 | 3374.99 | 0.00 | 4780.99 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Xu, Kristen,15751 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Sanchez, Bryant, C,13113 | 6832.41 | 0.00 | 0.00 | 2071.42 | 4760.99 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Chander, Tonya,15794 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Kovar, Mayra, J,17312 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Shan, Darrell, J,27345 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 0.00 | 2071.42 | 4715.33 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Lin, Kelli, A,21392 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Suri, Adriana,18463 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Carlson, Jay,20264 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Hernandez, Jésus, M,24267 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Sanchez, Joel,18468 | 5333.25 | 0.00 | 3578.27 | 1754.98 | 0.00 |
| Sara, Tina,24307 | 4158.32 | 0.00 | 0.00 | 2443.35 | 1714.97 |
| Kumar, Deborah, K,17308 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Gonzalez, Carolyn, H,22407 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Patel, Meredith,18333 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| She, Glenn, L,29117 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Alexander, Alyssa, M,17282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Lal, Barbara, W,23101 | 2795.01 | 0.00 | 0.00 | 2181.56 | 613.45 |
| Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Moreno, Pedro, A,18248 | 6037.89 | 0.00 | 3578.27 | 0.00 | 2459.62 |
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Dominguez, Gina, L,20213 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Beck, Alicia, L,17248 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Mehta, Heidi,14226 | 5656.24 | 0.00 | 0.00 | 2071.42 | 3584.82 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Raji, Dale,19265 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Martin, Ricky, C,16608 | 101.57 | 0.00 | 0.00 | 0.00 | 101.57 |
| Wu, Margaret,28928 | 2473.05 | 0.00 | 0.00 | 0.00 | 2473.05 |
| Rana, Cory, E,16173 | 43.21 | 0.00 | 0.00 | 0.00 | 43.21 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 0.00 | 2443.35 | 1798.96 |
| Cai, Steve, M,22155 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Suri, Allen,21553 | 4666.50 | 0.00 | 0.00 | 2181.56 | 2484.94 |
| Wilson, Edward, L,26562 | 1925.41 | 0.00 | 0.00 | 782.99 | 1142.42 |
| Navarro, Albert, L,21561 | 4947.78 | 0.00 | 2443.35 | 0.00 | 2504.43 |
| Jiménez, Daisy,21944 | 4713.89 | 0.00 | 0.00 | 2181.56 | 2532.33 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Madan, Stanley,19602 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Rubio, Kristy,12243 | 3914.98 | 0.00 | 3374.99 | 0.00 | 539.99 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Jai, Dylan, J,23128 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Suri, Kari,25266 | 57.98 | 0.00 | 0.00 | 0.00 | 57.98 |
| Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 0.00 | 58.16 |
| Lal, Karla,25219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| She, Yolanda, M,18304 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
| Weber, Jay, A,25244 | 21.93 | 0.00 | 0.00 | 0.00 | 21.93 |
| Gill, Diane,15578 | 4509.90 | 0.00 | 0.00 | 2071.42 | 2438.48 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Navarro, Tyrone, K,25557 | 1262.87 | 0.00 | 699.10 | 0.00 | 563.77 |
| Deng, Carl,18284 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Ruiz, Alberto, L,25212 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Kapoor, Jay, F,21956 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Ye, Dennis, M,16638 | 5974.23 | 0.00 | 3578.27 | 0.00 | 2395.96 |
| Rai, Terrence, R,25037 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Ye, Edwin,18334 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Moreno, Jessie, C,22906 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Blanco, Hector, J,22938 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Jai, Nichole, R,28348 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Kumar, Jenny, C,23429 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Sharma, Tony,18241 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Arthur, Carla,16710 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Walker, Anthony, T,25250 | 1883.56 | 699.10 | 0.00 | 0.00 | 1184.46 |
| Nara, Michele, R,22842 | 86.46 | 0.00 | 0.00 | 0.00 | 86.46 |
| Andersen, Colin,25053 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Chander, Alejandro, M,24455 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Deng, Russell, J,20314 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Kovár, Donald, M,24277 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Yang, Crystal, A,23665 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Raje, Karla,28936 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
Generated 2025-12-21 19:38:42.645 UTC