[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1000 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Raji, Bradley, E,17925 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Suri, Phillip,17914 | 4698.76 | 0.00 | 3578.27 | 0.00 | 1120.49 |
| Garcia, Charles, M,20250 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Huang, Micah,25130 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Anand, Ricardo,21383 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Chander, Maurice, L,14086 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Andersen, Jaime,25268 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Anderson, Victoria,15799 | 4423.38 | 0.00 | 0.00 | 2071.42 | 2351.96 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Kumar, Barbara, N,27499 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Shen, Roger, G,14011 | 3831.89 | 0.00 | 0.00 | 3831.89 | 0.00 |
| James, Mariah, M,19104 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Wu, Laura,20615 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Black, Shawna, C,15205 | 4433.69 | 0.00 | 0.00 | 2071.42 | 2362.27 |
| Zhang, Cara,12351 | 117.97 | 0.00 | 0.00 | 0.00 | 117.97 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| Moreno, Dwayne, T,23103 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Hernandez, Victor, T,23537 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ashe, Misty, R,23129 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 0.00 | 2071.42 | 4736.03 |
| Tang, Latoya, F,22910 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Raman, Edgar, A,27596 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Sai, Martin, L,21221 | 29.99 | 0.00 | 0.00 | 0.00 | 29.99 |
| Russell, Jonathan,18896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Wu, Alisha,23654 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Moreno, Diana, J,29298 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Serrano, Tyrone,11360 | 5025.80 | 0.00 | 3399.99 | 0.00 | 1625.81 |
| Shen, Katie, A,20283 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Madan, Terrance,24910 | 2183.91 | 0.00 | 0.00 | 1000.44 | 1183.47 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Lopez, George,15040 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Carlson, Theresa, L,19629 | 109.44 | 0.00 | 0.00 | 0.00 | 109.44 |
| Shen, Alisha, J,26438 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Schmidt, Joe, M,22905 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Serrano, Darren,29196 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Torres, Monique,25235 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Dominguez, Roy, C,29189 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Chander, Yolanda,16519 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Perez, Evelyn,14346 | 3583.26 | 0.00 | 0.00 | 2071.42 | 1511.84 |
| Yuan, Jon,25937 | 1299.56 | 0.00 | 699.10 | 0.00 | 600.46 |
| Raje, Marshall, J,19267 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Rubio, Daisy, A,16181 | 170.06 | 0.00 | 0.00 | 0.00 | 170.06 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Henderson, Paige, C,17325 | 54.94 | 0.00 | 0.00 | 0.00 | 54.94 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Guo, Jon,22927 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 0.00 | 2049.10 | 4768.04 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 101.93 | 7.95 |
| Weber, Deanna, L,14855 | 3759.08 | 0.00 | 0.00 | 2049.10 | 1709.98 |
| Collins, Andrea,12250 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Fernandez, Michele, M,24884 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Shen, Alison, A,16614 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Andersen, Tracy,20815 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Zhu, Damien, M,15822 | 43.21 | 0.00 | 0.00 | 0.00 | 43.21 |
| Navarro, Kristy, J,19570 | 74.94 | 0.00 | 0.00 | 45.95 | 28.99 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Rai, Bradley,19100 | 79.26 | 0.00 | 0.00 | 0.00 | 79.26 |
| Guo, Jake, P,19969 | 98.45 | 0.00 | 0.00 | 67.97 | 30.48 |
| Pal, Mohamed, D,12698 | 6786.75 | 0.00 | 2071.42 | 0.00 | 4715.33 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Ms., Schultz, Barbara, R.,15811 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Suarez, Hector, L,15034 | 103.45 | 0.00 | 0.00 | 8.99 | 94.46 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 0.00 | 3577.82 | 0.00 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Bryant, Fernando, M,20609 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Vance, Henry,27986 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 31.27 | 9.99 |
| Zhu, Tiffany,26437 | 1953.47 | 0.00 | 0.00 | 782.99 | 1170.48 |
| Suri, Molly,17503 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Stewart, Margaret, C,29096 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 782.99 | 556.93 |
| Navarro, Marc,16346 | 37.55 | 0.00 | 0.00 | 0.00 | 37.55 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Rodriguez, Ruth, R,26179 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Suri, Whitney, J,21974 | 4925.17 | 0.00 | 0.00 | 2443.35 | 2481.82 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Gill, Carolyn,23094 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Romero, Gina,14234 | 5687.72 | 0.00 | 0.00 | 2071.42 | 3616.30 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 2443.35 | 0.00 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Lal, Cristina, M,14671 | 2934.37 | 0.00 | 0.00 | 2071.42 | 862.95 |
| Raman, Cindy,16157 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Zhou, Gilbert,24475 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Jimenez, Erik, H,21989 | 35.00 | 0.00 | 0.00 | 35.00 | 0.00 |
| Jai, Michele, E,21225 | 4732.86 | 0.00 | 2181.56 | 0.00 | 2551.30 |
| Hernandez, Erika,16160 | 2644.07 | 0.00 | 0.00 | 2049.10 | 594.97 |
| Li, Jenny, B,22169 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Shan, Jenny, W,16706 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
| Sharma, Mario, J,25928 | 1316.05 | 0.00 | 699.10 | 0.00 | 616.95 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Raje, Lindsay, L,20613 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Garcia, Toni,22193 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Rai, Shaun,26431 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Alvarez, Kendra, R,15267 | 2853.58 | 0.00 | 0.00 | 2049.10 | 804.48 |
| Lal, Nina, L,14263 | 5647.93 | 0.00 | 0.00 | 2049.10 | 3598.83 |
| Yang, Curtis,11110 | 8093.03 | 0.00 | 3399.99 | 2294.99 | 2398.05 |
| Jones, Nathan,15024 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Rubio, Monique, M,29101 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
Generated 2025-11-04 11:47:57.902 UTC