[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 SHUFFLE < SKIP 1875 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sullivan, Ruth,27723 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Chavez, Kurt, C,23563 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| She, Willie,17055 | 4347.76 | 3578.27 | 0.00 | 0.00 | 769.49 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Ramos, Meredith, A,23307 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 53.99 | 29.99 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Madan, Martin, M,24911 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Martin, Beth, K,23317 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gill, Erika, A,18202 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Ramos, Victor, D,24246 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Gutierrez, Desiree,15216 | 101.74 | 0.00 | 0.00 | 27.28 | 74.46 |
| Gonzales, Victoria,11751 | 8215.02 | 0.00 | 3399.99 | 2430.96 | 2384.07 |
| He, Curtis, D,24921 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Sara, Cassandra, D,20989 | 4148.74 | 0.00 | 3578.27 | 0.00 | 570.47 |
| Anderson, Richard, G,24924 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Goel, Michele,15041 | 3826.40 | 0.00 | 0.00 | 2071.42 | 1754.98 |
| She, Rosa,18931 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Munoz, Shannon, S,29122 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Gonzalez, Brandy,27368 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Hernandez, Erik, C,21998 | 56.98 | 0.00 | 0.00 | 0.00 | 56.98 |
| Luo, Maurice, C,27491 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Pal, Christine, I,18242 | 6121.71 | 0.00 | 3578.27 | 2543.44 | 0.00 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Lopez, Isaac,27692 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Yuan, Calvin,17905 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Chen, Cedric, R,17065 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Romero, Francis,22196 | 4632.86 | 0.00 | 0.00 | 2181.56 | 2451.30 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| He, Dennis, J,27878 | 1283.82 | 0.00 | 0.00 | 0.00 | 1283.82 |
| Xu, Glenn,18743 | 67.21 | 0.00 | 0.00 | 0.00 | 67.21 |
| Lal, Drew, A,28325 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Rodriguez, Tammy,15233 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Ross, Brandon,14132 | 3804.08 | 0.00 | 0.00 | 2049.10 | 1754.98 |
| Nara, Devon, C,21964 | 103.49 | 0.00 | 0.00 | 0.00 | 103.49 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Hernandez, Audrey,18290 | 84.96 | 0.00 | 0.00 | 8.99 | 75.97 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Sullivan, Carla, A,20611 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Li, Justin,14124 | 57.59 | 0.00 | 0.00 | 0.00 | 57.59 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Washington, Marcus,28329 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Rodriguez, Donald, L,28351 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Luo, Jerry, M,24586 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Zhou, Krystal,23593 | 3990.01 | 0.00 | 0.00 | 2181.56 | 1808.45 |
| Gutierrez, Orlando,25920 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Jimenez, Neil,22151 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Liang, Ronnie,24584 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Malhotra, Emmanuel,18332 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Suarez, Alberto, G,18719 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Srini, Darren, P,15591 | 4346.38 | 0.00 | 0.00 | 2049.10 | 2297.28 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bradley, Victoria,29454 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Zhao, Micah,18708 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Suri, Arthur,26190 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Raji, Dawn, C,20244 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| Russell, Noah, M,26447 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 0.00 | 2049.10 | 4688.05 |
| Patterson, Kyle,11448 | 8132.01 | 0.00 | 3374.99 | 2318.96 | 2438.06 |
| Alonso, Armando, M,13647 | 6793.15 | 0.00 | 0.00 | 2049.10 | 4744.05 |
| Liu, Dennis,29062 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Ramos, Roberto, M,13159 | 208.18 | 0.00 | 0.00 | 0.00 | 208.18 |
| Zhu, Wesley, L,19624 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Romero, Kathleen,14019 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Sai, Ivan, E,17300 | 94.22 | 0.00 | 0.00 | 0.00 | 94.22 |
| Zheng, Edwin, J,14216 | 5653.92 | 0.00 | 0.00 | 2049.10 | 3604.82 |
| Dominguez, Theresa, L,18769 | 5304.25 | 0.00 | 3578.27 | 0.00 | 1725.98 |
| Lu, Margaret, D,20814 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Rai, Michele, M,26567 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Xie, Cristina, C,17050 | 4496.23 | 3578.27 | 0.00 | 0.00 | 917.96 |
| She, Ashlee,28319 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 0.00 | 2492.32 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Shan, Johnny,11999 | 7043.27 | 0.00 | 3399.99 | 0.00 | 3643.28 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| Rubio, Derrick, P,23525 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Wright, Miguel,25811 | 86.45 | 0.00 | 0.00 | 86.45 | 0.00 |
| Perez, Virginia, A,27494 | 1952.45 | 0.00 | 0.00 | 782.99 | 1169.46 |
| Liu, Cedric,12677 | 6785.47 | 0.00 | 2071.42 | 0.00 | 4714.05 |
| Li, Elijah,16740 | 6099.10 | 3578.27 | 0.00 | 2520.83 | 0.00 |
| Mr., Shen, Alan,24257 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Kapoor, Kaitlin, M,17072 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 2394.97 | 2398.05 |
| She, Jessie, A,13650 | 6768.14 | 0.00 | 0.00 | 2049.10 | 4719.04 |
| Ma, Dawn, A,13956 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Gutierrez, Diana,19676 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| Chapman, Kristi, l,21986 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Pal, Peter, K,22848 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Gao, Amy,21996 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Miller, Zachary, M,15169 | 2919.89 | 0.00 | 0.00 | 2071.42 | 848.47 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lu, Tiffany,22843 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Lu, Trisha,25555 | 1277.56 | 699.10 | 0.00 | 0.00 | 578.46 |
| Li, Lacey,17515 | 4143.26 | 0.00 | 3578.27 | 0.00 | 564.99 |
| Vazquez, Juan, P,22578 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Jai, Tasha, A,19771 | 4167.23 | 0.00 | 3578.27 | 588.96 | 0.00 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Carlson, Wendy,20220 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
Generated 2025-11-04 05:34:05.930 UTC