[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 60 > < TAKE 60 >
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Dominguez, Robyn, P,23305 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| She, Colin, M,15139 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Chande, Willie, B,16163 | 2641.39 | 0.00 | 0.00 | 2071.42 | 569.97 |
| Murphy, Jill, J,24902 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Ms., Sherwood, Irma, J.,24598 | 4228.31 | 0.00 | 0.00 | 2443.35 | 1784.96 |
| Black, Tonya, M,21254 | 89.97 | 0.00 | 0.00 | 0.00 | 89.97 |
| Martinez, Manuel, J,15832 | 2611.41 | 0.00 | 0.00 | 2071.42 | 539.99 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| Zhao, Susan, L,25122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nelson, Kaitlyn, J,24276 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Raje, Shawn,17054 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Long, Angelica, C,28206 | 2398.05 | 0.00 | 0.00 | 2398.05 | 0.00 |
| He, Dawn,15647 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Lu, Glenn,12692 | 156.26 | 0.00 | 0.00 | 0.00 | 156.26 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 0.00 | 102.85 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Shen, Grant, B,26763 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Martin, Lance,25236 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhou, Jon, L,11060 | 8153.02 | 0.00 | 3399.99 | 2319.99 | 2433.04 |
| Raman, Arthur,24001 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Munoz, Diane, R,15795 | 132.44 | 0.00 | 0.00 | 0.00 | 132.44 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Barnes, Faith, F,15726 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Zhu, Erica,25221 | 2143.90 | 0.00 | 0.00 | 1000.44 | 1143.46 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Jai, Michele, E,21225 | 4732.86 | 0.00 | 2181.56 | 0.00 | 2551.30 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Gonzalez, Dominique, J,27976 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Chandra, Rebekah,28486 | 776.33 | 0.00 | 0.00 | 0.00 | 776.33 |
| Ramos, Adrienne, L,28216 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Gao, Edwin,25716 | 1302.59 | 0.00 | 699.10 | 0.00 | 603.49 |
| Raje, Bonnie,20629 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Rana, Henry,27342 | 1348.46 | 0.00 | 0.00 | 782.99 | 565.47 |
| Chander, Carl,14315 | 109.71 | 0.00 | 0.00 | 0.00 | 109.71 |
| Torres, Gina,17904 | 4733.75 | 0.00 | 3578.27 | 0.00 | 1155.48 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Ms., Rousey, Linda, R.,21279 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Vazquez, Kristi,28349 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Cassandra, D,29068 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| Cox, Isaac,15797 | 4415.68 | 0.00 | 0.00 | 2071.42 | 2344.26 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Hill, Adam,18740 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Suarez, Meredith,15032 | 3800.08 | 0.00 | 0.00 | 2049.10 | 1750.98 |
| Shen, Barbara,22030 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Chander, Alejandro, M,24455 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Chander, Tonya,15794 | 113.97 | 0.00 | 0.00 | 0.00 | 113.97 |
| Sharma, Cedric, A,14060 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Serrano, Anne,24244 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Ashe, Joanna, F,20997 | 2744.52 | 0.00 | 2181.56 | 0.00 | 562.96 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Romero, Julio,22857 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Ortega, Dwayne, C,24615 | 2155.92 | 0.00 | 0.00 | 1000.44 | 1155.48 |
Generated 2025-12-21 22:24:32.690 UTC