[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 18 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chen, Tiffany, A,23348 | 4167.31 | 0.00 | 0.00 | 2443.35 | 1723.96 |
| Jai, Katrina,13044 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Miller, Taylor, M,18720 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Xie, Lindsey, M,25132 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sai, Ruth, D,24461 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Cai, Cedric,19559 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Suarez, Tabitha,25110 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Gonzalez, Michele, D,18491 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Yang, Heather,18275 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Liang, Margaret,17254 | 147.48 | 0.00 | 0.00 | 0.00 | 147.48 |
| Andersen, Kate,14237 | 90.25 | 0.00 | 0.00 | 0.00 | 90.25 |
| Garcia, Preston, M,24602 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raji, Karl,29103 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Romero, Wendy, H,11372 | 4965.81 | 0.00 | 3374.99 | 0.00 | 1590.82 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
| Lin, Bianca,11107 | 8171.01 | 0.00 | 3374.99 | 2376.96 | 2419.06 |
| Murphy, Jill, J,24902 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Sanchez, Michelle, R,26569 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Arun, Ross, C,23658 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Kumar, Luke,24161 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Madan, Rachael, R,16486 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Romero, Ebony, A,27717 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Nath, Ricardo, C,12039 | 8213.00 | 0.00 | 3374.99 | 0.00 | 4838.01 |
| Alonso, Gary, C,18767 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Raje, Kelli, A,28136 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Ye, Amy,11073 | 191.90 | 0.00 | 0.00 | 0.00 | 191.90 |
| Phillips, Jeremy, E,18495 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Srini, Douglas, M,16733 | 35.26 | 0.00 | 0.00 | 0.00 | 35.26 |
| Griffin, Caroline,17726 | 4721.73 | 0.00 | 3578.27 | 0.00 | 1143.46 |
| Johnston, Tamara, H,18492 | 218.26 | 0.00 | 0.00 | 0.00 | 218.26 |
| Ma, Jeffery,18264 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Li, Krystal, A,24912 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Martin, Ebony, F,15223 | 4366.41 | 0.00 | 0.00 | 2071.42 | 2294.99 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 0.00 | 40.96 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 0.00 | 2049.10 | 579.97 |
| Raji, Omar,15643 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Patel, Ann,21371 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Cai, Candice,26747 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Johnson, Elizabeth,11004 | 8196.01 | 3399.99 | 0.00 | 2376.96 | 2419.06 |
| Torres, Jacqueline,21976 | 4198.33 | 0.00 | 0.00 | 2443.35 | 1754.98 |
| Blanco, Micheal, A,11113 | 109.88 | 0.00 | 0.00 | 0.00 | 109.88 |
| Malhotra, Phillip, J,21977 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Nara, Tonya, C,17251 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Hu, Jenny, A,16634 | 106.56 | 0.00 | 0.00 | 0.00 | 106.56 |
| Blanco, Orlando,22575 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Nara, Calvin, J,11367 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| Huang, Arturo,28952 | 2473.04 | 0.00 | 0.00 | 0.00 | 2473.04 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Huang, Dawn, E,11943 | 4734.29 | 0.00 | 3374.99 | 539.99 | 819.31 |
| Lu, Roger, F,19763 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Flores, Brianna,27706 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
Generated 2026-01-04 04:32:26.876 UTC