[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 15 < SKIP 625 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Jenkins, Joan,16155 | 4489.57 | 0.00 | 0.00 | 2049.10 | 2440.47 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 123.96 | 62.98 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Arthur, Rebekah,22939 | 3961.03 | 0.00 | 0.00 | 2181.56 | 1779.47 |
| Dominguez, Stacy, S,19105 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Bhat, Edwin,13079 | 6752.13 | 0.00 | 0.00 | 2049.10 | 4703.03 |
| Lopez, Cesar,17500 | 156.96 | 0.00 | 0.00 | 0.00 | 156.96 |
| White, Olivia, E,18457 | 4826.23 | 0.00 | 3578.27 | 0.00 | 1247.96 |
| Rana, Ivan, K,18196 | 4133.24 | 0.00 | 3578.27 | 0.00 | 554.97 |
| Ma, Brittney,12584 | 2633.39 | 0.00 | 0.00 | 2071.42 | 561.97 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 0.00 | 64.95 |
| Fernandez, George,19974 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lu, Martha, R,21255 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Torres, Sebastian, V,25831 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Sai, Francisco, W,18766 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Lu, Darryl,27702 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Jai, Brendan,26755 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Carlson, Wendy,20220 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Martinez, Roy, J,13969 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| She, Kristin, L,19961 | 97.97 | 0.00 | 0.00 | 0.00 | 97.97 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Saunders, Jillian,21178 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| She, Jeffery, M,27149 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Gomez, Nelson, L,29053 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Xu, Mindy,20246 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Sanchez, Patrick, W,24382 | 143.78 | 0.00 | 0.00 | 0.00 | 143.78 |
| Fernandez, Candace,11105 | 8095.99 | 0.00 | 3399.99 | 2294.99 | 2401.01 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Munoz, Carolyn, L,17315 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Nath, Jaime,11033 | 6495.29 | 0.00 | 3374.99 | 0.00 | 3120.30 |
| Ma, Jorge, O,14052 | 86.26 | 0.00 | 0.00 | 27.28 | 58.98 |
| Williams, Anna, R,17504 | 4362.74 | 0.00 | 3578.27 | 0.00 | 784.47 |
| Gomez, Mallory, R,24898 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Navarro, Theresa,20627 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Gutierrez, Marvin,25938 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Alonso, Stacy,28315 | 556.93 | 0.00 | 0.00 | 0.00 | 556.93 |
| Chandra, Jermaine, A,14299 | 5108.76 | 0.00 | 0.00 | 2071.42 | 3037.34 |
| Sun, Clayton,28533 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Deng, Casey, C,19674 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Suri, Marie,24281 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Sara, Clifford, M,24178 | 2810.53 | 0.00 | 0.00 | 2181.56 | 628.97 |
| Cai, Trisha,18265 | 64.98 | 0.00 | 0.00 | 0.00 | 64.98 |
| Munoz, Teresa, R,27712 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Rodriguez, Dylan, E,16611 | 75.53 | 0.00 | 0.00 | 0.00 | 75.53 |
| Lin, Kelvin, A,13075 | 6843.94 | 0.00 | 0.00 | 2071.42 | 4772.52 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Ortega, Lawrence,14685 | 146.74 | 0.00 | 0.00 | 0.00 | 146.74 |
| Chande, Dale, K,17242 | 4387.23 | 0.00 | 3578.27 | 0.00 | 808.96 |
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2049.10 | 3200.82 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Kapoor, Troy, E,24610 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Arun, Denise,28218 | 18.97 | 0.00 | 0.00 | 0.00 | 18.97 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Suarez, Joy, B,12665 | 74.54 | 0.00 | 0.00 | 0.00 | 74.54 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Huang, Wesley,29320 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Yang, Connor,17735 | 4752.75 | 0.00 | 3578.27 | 0.00 | 1174.48 |
Generated 2025-12-23 07:19:41.656 UTC