[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 1125 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
|---|---|---|---|---|---|
| Allen, Alexandra, B,17293 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Lin, Alan,22973 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Arun, Bryant, C,20453 | 21.49 | 0.00 | 0.00 | 21.49 | 0.00 |
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 24.49 | 33.56 |
| Schmidt, Shane,17922 | 4821.72 | 3578.27 | 0.00 | 0.00 | 1243.45 |
| Kumar, Kurt, L,27360 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Bell, Jessica,22178 | 4233.32 | 0.00 | 2443.35 | 0.00 | 1789.97 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2867.76 | 2369.97 |
| Bradley, Emma,14211 | 5662.90 | 0.00 | 0.00 | 2049.10 | 3613.80 |
| Henderson, Isabella, L,21981 | 75.97 | 0.00 | 0.00 | 0.00 | 75.97 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 2120.93 | 0.00 |
| Blanco, Sheila, I,17724 | 36.96 | 0.00 | 0.00 | 0.00 | 36.96 |
| Kapoor, Veronica, G,20253 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Diaz, Josue,15207 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Zhu, Jake, G,24603 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Pal, Gilbert,27744 | 643.95 | 0.00 | 0.00 | 643.95 | 0.00 |
| Fernandez, Kristi,19585 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Cai, Suzanne,25051 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Torres, Marc,11765 | 8143.03 | 0.00 | 3374.99 | 2294.99 | 2473.05 |
| Beck, Barbara,26547 | 1407.96 | 0.00 | 0.00 | 782.99 | 624.97 |
| Suri, Erick,16635 | 38.88 | 0.00 | 0.00 | 38.88 | 0.00 |
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Yang, Connor,17735 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Cai, Susan,19101 | 104.42 | 0.00 | 0.00 | 0.00 | 104.42 |
| Li, Cedric,27364 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Dominguez, Diana, L,29292 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Yuan, Sharon,12008 | 55.76 | 0.00 | 0.00 | 0.00 | 55.76 |
| Madan, Marco,18895 | 27.77 | 0.00 | 0.00 | 27.77 | 0.00 |
| Garcia, Donald,18929 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Srini, Kristopher, A,23997 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Hu, Alvin, E,11449 | 8130.32 | 0.00 | 3374.99 | 2362.27 | 2393.06 |
| Zeng, Alvin, M,11118 | 115.85 | 0.00 | 0.00 | 0.00 | 115.85 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Munoz, Anne,15798 | 98.96 | 0.00 | 0.00 | 34.99 | 63.97 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Carlson, Kristy,28217 | 2408.29 | 0.00 | 0.00 | 2408.29 | 0.00 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Wang, Alejandro,17310 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Carlson, Jay,20264 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Xu, Cristina,25017 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Moreno, Larry, W,28207 | 2461.55 | 0.00 | 0.00 | 2461.55 | 0.00 |
| Arun, Nancy, C,21169 | 4647.88 | 0.00 | 2181.56 | 0.00 | 2466.32 |
| Mehta, Brandy,22839 | 39.25 | 0.00 | 0.00 | 39.25 | 0.00 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Cox, Catherine, K,13122 | 6871.43 | 0.00 | 0.00 | 2071.42 | 4800.01 |
| Tang, Dawn, R,16496 | 5960.23 | 3578.27 | 0.00 | 0.00 | 2381.96 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Anand, Tamara,29088 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Holt, Alisha,28350 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Vance, Kristi, T,28338 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Sai, Barry,22907 | 4169.33 | 0.00 | 0.00 | 2443.35 | 1725.98 |
| Jiménez, Deanna,28115 | 562.96 | 0.00 | 0.00 | 562.96 | 0.00 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Xu, Kelsey, W,28220 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| She, Colleen, E,29312 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Vazquez, Jerome,23116 | 3936.54 | 0.00 | 0.00 | 3936.54 | 0.00 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Jiménez, Bruce, L,23640 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Mr., Rovira Diez, Pablo,21190 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Wood, Julia, L,12356 | 6810.13 | 0.00 | 2049.10 | 2341.97 | 2419.06 |
| Hernandez, Melinda,16174 | 140.45 | 0.00 | 0.00 | 92.48 | 47.97 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Carson, Kristin, C,24459 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Chander, Devon,24612 | 2152.20 | 0.00 | 1000.44 | 1151.76 | 0.00 |
| Garcia, Holly,26558 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Chandra, Cynthia,22000 | 4663.79 | 0.00 | 2181.56 | 0.00 | 2482.23 |
| Taylor, Devin, L,12248 | 3939.98 | 0.00 | 3399.99 | 0.00 | 539.99 |
| Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
| Yang, Lacey,13150 | 89.24 | 0.00 | 0.00 | 0.00 | 89.24 |
| Xu, Alan,16741 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Martin, Casey, J,22962 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nath, Bethany,16177 | 133.34 | 0.00 | 0.00 | 0.00 | 133.34 |
| Andersen, Drew, K,22412 | 3018.33 | 0.00 | 2443.35 | 0.00 | 574.98 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Serrano, Natasha,25563 | 1239.09 | 699.10 | 0.00 | 0.00 | 539.99 |
| Shan, Gregory,20614 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Martin, Meghan, B,26773 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Rivera, Jada,21970 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Shan, Carl, D,24919 | 2212.89 | 0.00 | 0.00 | 2212.89 | 0.00 |
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Hu, Susan,25242 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Sai, Monica, L,29055 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Raman, Geoffrey, P,15435 | 3801.39 | 0.00 | 0.00 | 2071.42 | 1729.97 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Ruiz, Leslie, J,26032 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Patel, Gerald,23095 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lopez, Bruce,23540 | 3626.82 | 0.00 | 0.00 | 3626.82 | 0.00 |
| Ma, Christy,15020 | 40.26 | 0.00 | 0.00 | 0.00 | 40.26 |
| Flores, Alexandra, C,26165 | 1957.47 | 0.00 | 782.99 | 0.00 | 1174.48 |
| Liu, Suzanne,19594 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Lin, Bianca,11107 | 8171.01 | 3374.99 | 0.00 | 2376.96 | 2419.06 |
| Lal, Kelsey, T,24913 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Shan, Keith, T,20996 | 4149.99 | 0.00 | 3578.27 | 571.72 | 0.00 |
| Jenkins, Amanda,15214 | 4490.88 | 0.00 | 0.00 | 2071.42 | 2419.46 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Kumar, Tony, P,19783 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Mehta, Patricia, K,29179 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Nath, Jaime,11033 | 6495.29 | 3374.99 | 0.00 | 0.00 | 3120.30 |
| Garcia, Frederick, J,16489 | 112.73 | 0.00 | 0.00 | 112.73 | 0.00 |
| Jimenez, Felicia, L,11075 | 8068.03 | 3374.99 | 0.00 | 2294.99 | 2398.05 |
| Butler, Carson, T,12672 | 381.97 | 0.00 | 0.00 | 159.00 | 222.97 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 588.96 | 0.00 |
| Andersen, Gilbert, T,27353 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Gonzalez, George, L,11942 | 4792.29 | 0.00 | 3399.99 | 614.96 | 777.34 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Raje, Donna, A,20607 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 2477.53 | 0.00 |
| Lopez, Terrance, T,14217 | 139.45 | 0.00 | 0.00 | 89.46 | 49.99 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 96.75 | 0.00 |
| Suri, Roy, M,17253 | 53.99 | 0.00 | 0.00 | 53.99 | 0.00 |
| King, Nathan,27719 | 599.47 | 0.00 | 0.00 | 0.00 | 599.47 |
| Carlson, Clinton, E,11116 | 148.70 | 0.00 | 0.00 | 27.28 | 121.42 |
| Black, Tommy,24376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
Generated 2024-09-20 05:31:24.506 UTC