[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1688 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Stewart, Margaret, C,29096 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Gomez, Derrick,18694 | 6035.60 | 0.00 | 3578.27 | 2457.33 | 0.00 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Collins, Jennifer,11364 | 4921.82 | 0.00 | 3374.99 | 0.00 | 1546.83 |
| Martin, Naomi, A,15593 | 116.26 | 0.00 | 0.00 | 88.98 | 27.28 |
| Raman, Jay, M,13618 | 6763.15 | 0.00 | 0.00 | 2049.10 | 4714.05 |
| Liang, Tiffany,11068 | 113.36 | 0.00 | 0.00 | 0.00 | 113.36 |
| Huang, Vincent, A,18703 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 2478.24 | 0.00 |
| Martinez, Pamela, A,13529 | 4614.86 | 0.00 | 0.00 | 2071.42 | 2543.44 |
| Zhao, Ernest, C,18700 | 5328.23 | 0.00 | 3578.27 | 1749.96 | 0.00 |
| Li, Trisha, A,18296 | 6117.69 | 0.00 | 3578.27 | 2539.42 | 0.00 |
| He, Omar,15831 | 2646.36 | 0.00 | 0.00 | 2646.36 | 0.00 |
| Wood, Sydney,23310 | 3333.32 | 0.00 | 0.00 | 3333.32 | 0.00 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Gonzalez, Devin,18485 | 6063.21 | 0.00 | 3578.27 | 2484.94 | 0.00 |
| Zheng, Omar, C,14522 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Nara, Johnny, R,18489 | 6081.10 | 0.00 | 3578.27 | 2502.83 | 0.00 |
| Gill, Byron, J,18483 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Nath, Omar, F,14672 | 5237.72 | 0.00 | 0.00 | 2071.42 | 3166.30 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Rai, Brad, S,18490 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Ramos, Byron,14306 | 3653.23 | 0.00 | 0.00 | 2071.42 | 1581.81 |
| Wang, Randy, G,25125 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Dominguez, Joy,22175 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Srini, Jay, M,18326 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Wu, Christy, D,25568 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Sutton, Kern, A,26660 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Raje, Jenny,20233 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Goel, Carl, S,17249 | 4426.74 | 3578.27 | 0.00 | 0.00 | 848.47 |
| Sara, Barry, R,13965 | 6872.39 | 0.00 | 0.00 | 2071.42 | 4800.97 |
| Sharma, Misty,25708 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Xu, Kara, E,22212 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 32.27 | 197.98 |
| Prasad, Brett, A,20262 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Chande, Jaclyn, S,18698 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Serrano, Jacquelyn,21963 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Huang, Crystal, L,26023 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
| Xie, Wayne, S,18302 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Russell, Cassidy, N,26144 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Weber, Cory,16739 | 81.26 | 0.00 | 0.00 | 31.27 | 49.99 |
| Hernandez, Beth, L,29084 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 32.27 | 36.43 |
| Patel, Marco, L,19575 | 60.05 | 0.00 | 0.00 | 23.78 | 36.27 |
| Rodriguez, Jonathan, J,13046 | 64.97 | 0.00 | 0.00 | 29.98 | 34.99 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
Generated 2025-11-07 03:02:12.103 UTC