[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Wang, Alejandro,17310 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Munoz, Jacquelyn,29115 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Guo, Susan, A,26543 | 14.23 | 0.00 | 0.00 | 0.00 | 14.23 |
| Sharma, Mario, J,25928 | 1316.05 | 0.00 | 699.10 | 0.00 | 616.95 |
| Diaz, Danny, C,18190 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Allen, Luis, C,26019 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Prasad, Cory,19748 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Jai, Jaime, M,24894 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sai, Francisco, W,18766 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Wu, Christy, D,25568 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Lopez, Adriana, A,12002 | 8145.33 | 0.00 | 3374.99 | 0.00 | 4770.34 |
| Madan, Stanley,19602 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Vazquez, Anne,16027 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| Huang, Jorge,17291 | 86.27 | 0.00 | 0.00 | 53.99 | 32.28 |
| Navarro, Jacquelyn,15465 | 40.23 | 0.00 | 0.00 | 0.00 | 40.23 |
| Chander, Misty,17333 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Ramos, Carolyn,17926 | 4715.70 | 0.00 | 3578.27 | 0.00 | 1137.43 |
| Alan, Meghan, I,28210 | 564.48 | 0.00 | 0.00 | 0.00 | 564.48 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Serrano, Mallory, E,26751 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Becker, Gregory, M,13104 | 6894.44 | 0.00 | 0.00 | 2071.42 | 4823.02 |
| Martinez, Tina, J,18461 | 4748.24 | 0.00 | 3578.27 | 0.00 | 1169.97 |
| Suri, Douglas,19096 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Garcia, Chelsea,21961 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Tang, April, A,25935 | 1256.03 | 0.00 | 699.10 | 0.00 | 556.93 |
| Jai, Lacey, C,11371 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| She, Glenn, L,29117 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Raji, Sheena, J,18213 | 6070.59 | 0.00 | 3578.27 | 2492.32 | 0.00 |
| Xu, Tony, L,22576 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Nara, Grant,12995 | 6850.58 | 0.00 | 0.00 | 2049.10 | 4801.48 |
| Lewis, Justin, L,28303 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Ortega, Felicia, J,11753 | 47.92 | 0.00 | 0.00 | 0.00 | 47.92 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Serrano, Joy, L,14069 | 173.94 | 0.00 | 0.00 | 0.00 | 173.94 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Martin, Roy,22065 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Ma, Louis,21879 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Kumar, Robert,25226 | 2158.90 | 0.00 | 0.00 | 1000.44 | 1158.46 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 0.00 | 2181.56 | 2523.92 |
| Sharma, Lindsay, E,24478 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Browning, Javier,23120 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 0.00 | 4768.04 |
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Martinez, Ann,12009 | 8195.50 | 0.00 | 3399.99 | 0.00 | 4795.51 |
| Tang, Julie,26589 | 1966.46 | 0.00 | 0.00 | 782.99 | 1183.47 |
| Sun, Jenny, L,12253 | 4066.93 | 0.00 | 3399.99 | 0.00 | 666.94 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Navarro, Mallory,24365 | 3331.03 | 0.00 | 0.00 | 2181.56 | 1149.47 |
| Sai, Bryant, S,22577 | 2743.04 | 0.00 | 0.00 | 2181.56 | 561.48 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Holt, Krystal,16518 | 4698.76 | 3578.27 | 0.00 | 0.00 | 1120.49 |
| Gomez, Ricky,18737 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Rana, Ross,25240 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Lu, Ronnie,19950 | 6098.54 | 0.00 | 3578.27 | 0.00 | 2520.27 |
| Zhao, Kelvin,25135 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Deng, Kate, L,15723 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
| Diaz, Dana, C,12361 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 0.00 | 184.48 |
| Diaz, Carolyn, C,24360 | 3626.82 | 0.00 | 0.00 | 2443.35 | 1183.47 |
| Ashe, Tara, J,19093 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Rogers, Anna,21201 | 4921.69 | 0.00 | 2443.35 | 0.00 | 2478.34 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 0.00 | 4492.45 | 0.00 |
| Bryant, Madison, J,16481 | 194.91 | 0.00 | 0.00 | 0.00 | 194.91 |
| Powell, Amanda,28113 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Raje, Johnny,13975 | 5138.72 | 0.00 | 0.00 | 2049.10 | 3089.62 |
| Diaz, Jay,16692 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Liu, Kelli, A,24480 | 4175.61 | 0.00 | 0.00 | 2443.35 | 1732.26 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Johnsen, Willie,15218 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Malhotra, Darren, L,20245 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Malhotra, Brett, E,18731 | 6054.06 | 0.00 | 3578.27 | 0.00 | 2475.79 |
| Liu, Lacey, L,23545 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Goel, Nichole, A,17277 | 4426.74 | 0.00 | 3578.27 | 0.00 | 848.47 |
| Madan, Joe,29300 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yang, Hunter, E,20237 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Nath, Tasha, J,18487 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 782.99 | 561.48 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Nara, Priscilla,18907 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Navarro, Carolyn,11069 | 8104.05 | 0.00 | 3399.99 | 2319.99 | 2384.07 |
| Vazquez, Ruben, B,14301 | 5142.75 | 0.00 | 0.00 | 2071.42 | 3071.33 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 0.00 | 1297.32 |
| Liu, Bianca, K,11458 | 31.92 | 0.00 | 0.00 | 0.00 | 31.92 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gill, Diane,15578 | 4509.90 | 0.00 | 0.00 | 2071.42 | 2438.48 |
| Goel, Derek,17045 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Arun, Gerald,25940 | 1277.56 | 0.00 | 699.10 | 0.00 | 578.46 |
| Hill, Jennifer,18291 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Gao, Randy,25113 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Gutierrez, Philip, M,21979 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Navarro, Rodney, L,29309 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Raje, Arturo, C,14228 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Navarro, Janet, J,28320 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Parker, Gabriel,19606 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Deng, Michele,21946 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Guo, Louis, D,15764 | 4413.39 | 0.00 | 0.00 | 2071.42 | 2341.97 |
| Martin, Jaime,28316 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Rivera, Jada,21970 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Suarez, Dana, M,23541 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
Generated 2025-12-21 03:47:53.109 UTC