[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < SKIP 63 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ye, Tamara, A,20243 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Lal, Shaun, H,17056 | 4417.75 | 3578.27 | 0.00 | 0.00 | 839.48 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Sharma, Andres, C,24230 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| James, Brooke,18745 | 78.26 | 0.00 | 0.00 | 0.00 | 78.26 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
| Shen, Katie, A,20283 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Wang, Nathan,14039 | 6808.13 | 0.00 | 0.00 | 2049.10 | 4759.03 |
| Li, Stacey,14064 | 5694.21 | 0.00 | 0.00 | 2071.42 | 3622.79 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 34.89 | 94.46 |
| Gao, Tiffany, E,16352 | 5948.49 | 3578.27 | 0.00 | 0.00 | 2370.22 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 24.99 | 17.27 |
| Long, Mariah, C,16730 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 0.00 | 2071.42 | 4753.31 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Serrano, Audrey,18337 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Lin, Ronnie, D,21384 | 2921.02 | 0.00 | 2181.56 | 0.00 | 739.46 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Jenkins, Anna, M,17234 | 91.26 | 0.00 | 0.00 | 0.00 | 91.26 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Sanchez, Michele,23543 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Sai, Regina,21192 | 4229.32 | 0.00 | 2443.35 | 0.00 | 1785.97 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Chande, Dale, K,17242 | 4387.23 | 3578.27 | 0.00 | 0.00 | 808.96 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| Malhotra, Whitney, D,28944 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Ma, Cedric, W,11094 | 157.93 | 0.00 | 0.00 | 0.00 | 157.93 |
| Thompson, Cameron, M,16620 | 5895.24 | 3578.27 | 0.00 | 0.00 | 2316.97 |
| Martinez, Cory, A,15125 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Zheng, Alisha,22203 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Allen, Ian, A,16031 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Torres, Michele, A,16176 | 4404.08 | 0.00 | 0.00 | 2049.10 | 2354.98 |
| Prasad, Jarrod,11359 | 4960.07 | 0.00 | 3374.99 | 0.00 | 1585.08 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 78.98 | 8.99 |
| Jones, Ethan,13051 | 6831.74 | 0.00 | 0.00 | 2071.42 | 4760.32 |
| Xu, Keith, J,25124 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Lopez, Brenda,26592 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Moreno, Monique, R,23118 | 3913.82 | 0.00 | 0.00 | 2181.56 | 1732.26 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 0.00 | 2049.10 | 4717.53 |
| She, Jerry, C,14277 | 5196.74 | 0.00 | 0.00 | 2071.42 | 3125.32 |
| Jimenez, Naomi,24922 | 2145.92 | 0.00 | 0.00 | 1000.44 | 1145.48 |
| Jenkins, Wyatt,27987 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Navarro, Lori,21182 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lu, Valerie,22913 | 4684.39 | 0.00 | 0.00 | 2181.56 | 2502.83 |
| Dominguez, Jerome, F,22987 | 3942.03 | 0.00 | 0.00 | 2181.56 | 1760.47 |
| Liang, Kelvin, L,16616 | 5915.54 | 3578.27 | 0.00 | 0.00 | 2337.27 |
| Ramos, Monique,16495 | 6002.23 | 3578.27 | 0.00 | 0.00 | 2423.96 |
| Mehta, Levi, M,13110 | 5583.94 | 0.00 | 0.00 | 2049.10 | 3534.84 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Gill, Meredith, E,24268 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Arun, Levi, A,11074 | 94.19 | 0.00 | 0.00 | 49.97 | 44.22 |
| Ramirez, Olivia, D,19785 | 6076.61 | 0.00 | 3578.27 | 0.00 | 2498.34 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 0.00 | 190.23 |
| Rodriguez, Carolyn,21002 | 2992.33 | 0.00 | 2443.35 | 0.00 | 548.98 |
| Rai, Christy,16683 | 69.87 | 0.00 | 0.00 | 0.00 | 69.87 |
| Beck, Alisha, E,11463 | 47.92 | 0.00 | 0.00 | 7.95 | 39.97 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Madan, Patricia, L,22988 | 4194.33 | 0.00 | 0.00 | 2443.35 | 1750.98 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Lu, Darryl,27702 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Diaz, Kendra,13021 | 2668.38 | 0.00 | 0.00 | 2071.42 | 596.96 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Black, Tommy,24376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Zheng, Shannon, M,14678 | 49.99 | 0.00 | 0.00 | 49.99 | 0.00 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Romero, Jessie,25030 | 2180.41 | 0.00 | 0.00 | 1000.44 | 1179.97 |
| He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Rana, Joe, D,11916 | 8178.51 | 0.00 | 3374.99 | 2405.47 | 2398.05 |
| Perry, Madison, R,23308 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 93.49 | 53.99 |
| Vazquez, Byron,11122 | 42.93 | 0.00 | 0.00 | 7.95 | 34.98 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Chander, Marshall,19090 | 59.26 | 0.00 | 0.00 | 2.29 | 56.97 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Lal, Julie, A,28309 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Vazquez, Joanna, J,11990 | 8164.01 | 0.00 | 3374.99 | 0.00 | 4789.02 |
| Lin, Dawn, N,15805 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Suarez, Neil,15242 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Sun, Mandy, L,16694 | 78.20 | 0.00 | 0.00 | 39.22 | 38.98 |
| Suri, Kristopher, M,22849 | 50.23 | 0.00 | 0.00 | 0.00 | 50.23 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Ramos, Craig,14209 | 193.97 | 0.00 | 0.00 | 4.99 | 188.98 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 0.00 | 2443.35 | 2568.92 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 0.00 | 2049.10 | 594.92 |
| Kapoor, Brett, L,22147 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 32.28 | 8.99 |
| Xu, Tonya,17324 | 80.94 | 0.00 | 0.00 | 0.00 | 80.94 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rogers, Seth, R,14318 | 138.45 | 0.00 | 0.00 | 63.97 | 74.48 |
| Liang, Alejandro, W,29193 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Zheng, Curtis, S,23645 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Perez, Toni,15581 | 113.94 | 0.00 | 0.00 | 0.00 | 113.94 |
| Gomez, Danny, V,16636 | 5932.74 | 3578.27 | 0.00 | 0.00 | 2354.47 |
| Ma, Curtis,28119 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Kumar, Tonya, A,22934 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Lu, Alan,19761 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Ashe, Kathryn,16168 | 80.11 | 0.00 | 0.00 | 34.89 | 45.22 |
| Liang, Rosa, L,19770 | 4127.25 | 0.00 | 3578.27 | 548.98 | 0.00 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 21.98 | 104.98 |
| Chande, Warren,17307 | 132.95 | 0.00 | 0.00 | 132.95 | 0.00 |
| Anand, Andrés,11096 | 8063.04 | 0.00 | 3374.99 | 2294.99 | 2393.06 |
| Chavez, Colin,16032 | 90.95 | 0.00 | 0.00 | 21.98 | 68.97 |
| Li, Kristen, R,15153 | 113.97 | 0.00 | 0.00 | 88.98 | 24.99 |
| Sun, Karen, C,28208 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
Generated 2025-11-06 20:57:10.385 UTC