[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 96 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Moreno, Lori, M,15226 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Zheng, Darryl,18706 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Sanz, Craig, M,21993 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Bradley, Diane, A,15140 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Yang, Clarence, D,25121 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
| Madan, Brandy, A,27687 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Serrano, Derrick,16707 | 4377.75 | 0.00 | 3578.27 | 0.00 | 799.48 |
| Gutierrez, Carrie, C,28139 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Hernandez, Tabitha, L,19603 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Shen, Willie, S,18450 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 0.00 | 782.99 | 578.46 |
| Martin, Hector,27860 | 615.47 | 0.00 | 0.00 | 0.00 | 615.47 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Becker, Leonard, C,22405 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Sanz, Victor,17295 | 4392.74 | 0.00 | 3578.27 | 0.00 | 814.47 |
| Watson, Adrian, K,13641 | 144.74 | 0.00 | 0.00 | 0.00 | 144.74 |
| Zimmerman, Candice, J,26754 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Nath, Grant, A,28947 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Lopez, Mayra, E,27356 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Ortega, Reginald, K,26429 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Hernandez, Jaime,24170 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Chande, Latoya, M,23309 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
| Luo, Louis,11465 | 8158.04 | 0.00 | 3399.99 | 0.00 | 4758.05 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Sanz, Paula,26430 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Fernandez, Denise, A,18724 | 6056.51 | 0.00 | 3578.27 | 0.00 | 2478.24 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Rubio, Pedro, E,23098 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Vance, Jillian, D,15230 | 148.98 | 0.00 | 0.00 | 0.00 | 148.98 |
| Sun, Jorge,16025 | 3831.89 | 0.00 | 0.00 | 2071.42 | 1760.47 |
| Xu, Sharon, A,23344 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Zheng, Sandra, P,15141 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Ruiz, Frank, M,14260 | 3716.23 | 0.00 | 0.00 | 2071.42 | 1644.81 |
| Suri, Arthur,26190 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Alonso, Krista, P,20212 | 100.74 | 0.00 | 0.00 | 0.00 | 100.74 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Rana, Nancy, H,26150 | 1992.46 | 0.00 | 0.00 | 782.99 | 1209.47 |
| Diaz, Gloria,25270 | 1854.58 | 699.10 | 0.00 | 0.00 | 1155.48 |
| Sharma, Carl,21375 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Garcia, George,20160 | 4237.22 | 0.00 | 3578.27 | 0.00 | 658.95 |
| Mitchell, Wyatt, A,14048 | 5123.74 | 0.00 | 0.00 | 2071.42 | 3052.32 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 0.00 | 2049.10 | 579.97 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 2049.10 | 1785.97 |
| Gutierrez, Orlando,25920 | 1819.59 | 0.00 | 699.10 | 0.00 | 1120.49 |
| Perez, Joe, A,14326 | 5207.70 | 0.00 | 0.00 | 2071.42 | 3136.28 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Perez, Brett, M,28313 | 647.94 | 0.00 | 0.00 | 0.00 | 647.94 |
| Gill, Carolyn,23094 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Gill, Billy, L,16700 | 92.97 | 0.00 | 0.00 | 0.00 | 92.97 |
Generated 2025-12-21 21:20:28.811 UTC