[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1248 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Cox, Michelle, E,17328 | 4387.74 | 0.00 | 3578.27 | 0.00 | 809.47 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Kapoor, Regina,15810 | 67.17 | 0.00 | 0.00 | 0.00 | 67.17 |
| Gomez, Randall, R,11762 | 8228.01 | 0.00 | 3399.99 | 0.00 | 4828.02 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 0.00 | 62.46 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Deng, Deborah,23324 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
| Munoz, Tanya,23436 | 3950.52 | 0.00 | 0.00 | 2181.56 | 1768.96 |
| Rai, Clayton, K,20446 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Vazquez, Casey, S,13132 | 6880.62 | 0.00 | 0.00 | 2049.10 | 4831.52 |
| Ferrier, Jaclyn, D,17299 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Alexander, Hailey, C,19666 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Torres, Carolyn,15261 | 70.74 | 0.00 | 0.00 | 0.00 | 70.74 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Muñoz, Alberto, J,13008 | 125.51 | 0.00 | 0.00 | 0.00 | 125.51 |
| Beck, Alicia, L,17248 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Gao, Cara, B,15642 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Gray, Stephanie,17064 | 4506.76 | 0.00 | 3578.27 | 0.00 | 928.49 |
| Garcia, Holly,26558 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Sanz, Victor,17295 | 4392.74 | 0.00 | 3578.27 | 0.00 | 814.47 |
| Alexander, David,15783 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Kovar, Mayra, J,17312 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Rodriguez, Ebony,14517 | 82.97 | 0.00 | 0.00 | 0.00 | 82.97 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Navarro, Bruce, D,17353 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Foster, Maria, E,28715 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 0.00 | 4880.49 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Evans, Xavier,19098 | 122.24 | 0.00 | 0.00 | 0.00 | 122.24 |
| Goldstein, Dustin,12337 | 8137.01 | 0.00 | 3399.99 | 0.00 | 4737.02 |
| Chavez, Karla, K,16704 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Shan, Warren,21971 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Luo, Dustin,17240 | 4385.03 | 0.00 | 3578.27 | 0.00 | 806.76 |
| Vance, George, R,12038 | 66.76 | 0.00 | 0.00 | 0.00 | 66.76 |
| Sanchez, Troy, H,25559 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Andersen, Rafael, E,12691 | 247.46 | 0.00 | 0.00 | 0.00 | 247.46 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Liang, Eugene,13972 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Allen, Alexandra, B,17293 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
| Jiménez, Alberto, C,15215 | 4468.56 | 0.00 | 0.00 | 2049.10 | 2419.46 |
| Mr., Shakespear, Paul, J.,17326 | 4467.76 | 0.00 | 3578.27 | 0.00 | 889.49 |
| Ye, Erica, E,13010 | 5716.52 | 0.00 | 0.00 | 2071.42 | 3645.10 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Lal, Deborah, T,21982 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Suri, Molly,17503 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Hill, Jennifer,18291 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Wang, Jeffery, E,18188 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Raman, Jermaine, E,15228 | 4375.06 | 0.00 | 0.00 | 2049.10 | 2325.96 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Mehta, Nancy,18189 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Prasad, Brandy, P,14009 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Suarez, Meghan, L,22177 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Zhang, Aimee,26025 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Alonso, Brandi,17061 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Subram, Tabitha, C,17511 | 4150.53 | 0.00 | 3578.27 | 572.26 | 0.00 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Suri, Jillian, L,15180 | 4466.39 | 0.00 | 0.00 | 2071.42 | 2394.97 |
| Chandra, Harold, K,17236 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Nara, Leonard, G,11045 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Evans, Jonathan, D,15185 | 4393.70 | 0.00 | 0.00 | 2071.42 | 2322.28 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Moreno, Casey,20602 | 80.47 | 0.00 | 0.00 | 0.00 | 80.47 |
| Sun, Brittney,11365 | 5024.79 | 0.00 | 3374.99 | 0.00 | 1649.80 |
| Serrano, Orlando,19561 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Becker, Julie,13614 | 114.21 | 0.00 | 0.00 | 0.00 | 114.21 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Zhu, Jessie, D,12666 | 34.56 | 0.00 | 0.00 | 0.00 | 34.56 |
| Madan, Terrance,24910 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Perez, Allen, B,14229 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Kumar, Robert,25226 | 2158.90 | 0.00 | 0.00 | 1000.44 | 1158.46 |
| Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 0.00 | 71.25 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Patel, Douglas,17927 | 4726.04 | 0.00 | 3578.27 | 0.00 | 1147.77 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Sanz, Larry,14067 | 114.96 | 0.00 | 0.00 | 0.00 | 114.96 |
| Kumar, Bethany,29299 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Perez, Janelle,16172 | 186.04 | 0.00 | 0.00 | 0.00 | 186.04 |
| Chander, Julie, E,18763 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Suarez, Randall, M,28211 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sanchez, Ross,28310 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Malhotra, Cory, E,17923 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ramos, Carolyn,17926 | 4715.70 | 0.00 | 3578.27 | 0.00 | 1137.43 |
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Zeng, Micah, A,25561 | 1288.06 | 0.00 | 699.10 | 0.00 | 588.96 |
| Yuan, Calvin,17905 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Alonso, Jerome, H,27977 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Xu, Lacey, S,17913 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Pal, Terrence, M,13037 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 0.00 | 571.72 |
| Zhu, Jake, G,24603 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Ramos, Randall,21572 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Evans, Mason,15439 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Ramos, Mathew, E,28961 | 2478.04 | 0.00 | 0.00 | 0.00 | 2478.04 |
| Moreno, Tanya,11139 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Subram, Ross, L,23085 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Raji, Lindsey,18205 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Vazquez, Diane, D,11987 | 279.23 | 0.00 | 0.00 | 0.00 | 279.23 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Stone, Mitchell,25013 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Lin, Autumn, E,18272 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
Generated 2025-12-22 05:38:53.006 UTC