[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 45 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Hernandez, Jessie, A,24172 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Hernandez, Kristine,14286 | 5234.40 | 0.00 | 0.00 | 2049.10 | 3185.30 |
| Smith, Adriana,18702 | 5333.25 | 0.00 | 3578.27 | 0.00 | 1754.98 |
| Romero, Gary,22181 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Ramos, Leslie,15733 | 4443.55 | 0.00 | 0.00 | 2049.10 | 2394.45 |
| Sanchez, George, M,12680 | 6880.10 | 0.00 | 0.00 | 2049.10 | 4831.00 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Kumar, Derek, M,15135 | 4381.39 | 0.00 | 0.00 | 2071.42 | 2309.97 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 0.00 | 4720.33 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Yuan, Grant, C,24909 | 2149.91 | 0.00 | 0.00 | 1000.44 | 1149.47 |
| Goel, Katie, D,27708 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Zhou, Kelvin,20231 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Rana, Meagan, M,11914 | 8165.96 | 0.00 | 3374.99 | 0.00 | 4790.97 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Gao, Eugene,29464 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Huang, Lisa, L,14102 | 3667.23 | 0.00 | 0.00 | 2071.42 | 1595.81 |
| Moore, Nathan, N,28323 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Diaz, Megan, A,24303 | 4207.32 | 0.00 | 0.00 | 2443.35 | 1763.97 |
| Liang, Louis, M,12706 | 6851.41 | 0.00 | 0.00 | 2071.42 | 4779.99 |
| Rana, Ross,25240 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Sara, Edgar, A,11104 | 8173.03 | 0.00 | 3399.99 | 2334.98 | 2438.06 |
| Zheng, Jamie, L,22156 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perez, Stefanie,27518 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Sanz, Renee, L,14319 | 138.45 | 0.00 | 0.00 | 0.00 | 138.45 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
| Martin, Joan, R,25556 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Hu, Omar, S,28954 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
Generated 2025-12-21 05:00:15.206 UTC