[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 624 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Meredith, M,20621 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Guo, Micah, M,24163 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Dominguez, Kristine, A,14020 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Ms., Robinson, Dorothy, B.,11952 | 8169.00 | 0.00 | 3374.99 | 2395.96 | 2398.05 |
| Munoz, Latasha,11967 | 8153.02 | 0.00 | 3374.99 | 0.00 | 4778.03 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 36.27 | 122.24 |
| Gutierrez, Erika,17227 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Chande, Ashlee, N,23096 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Perez, Rachael, D,26762 | 133.49 | 0.00 | 0.00 | 0.00 | 133.49 |
| Andersen, Deborah,19610 | 118.94 | 0.00 | 0.00 | 0.00 | 118.94 |
| Liang, Tiffany,11068 | 113.36 | 0.00 | 0.00 | 0.00 | 113.36 |
| Lu, Micah,22174 | 3007.83 | 0.00 | 0.00 | 2443.35 | 564.48 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 0.00 | 3165.30 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 2071.42 | 0.00 | 4796.02 |
| Vazquez, Marc, H,24362 | 3600.77 | 0.00 | 0.00 | 2443.35 | 1157.42 |
| Wu, Lisa,26158 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Sun, Jamie,21389 | 2770.52 | 0.00 | 2181.56 | 0.00 | 588.96 |
| Mrs., Nara, Barbara,12704 | 217.46 | 0.00 | 0.00 | 0.00 | 217.46 |
| Goel, Roger, A,23652 | 3907.54 | 0.00 | 0.00 | 2181.56 | 1725.98 |
| Xu, Calvin, E,27583 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Gomez, Sheila, J,21165 | 4673.88 | 0.00 | 2181.56 | 0.00 | 2492.32 |
| Sun, Lacey, L,15131 | 81.26 | 0.00 | 0.00 | 0.00 | 81.26 |
| Edwards, Carlos,16680 | 104.86 | 0.00 | 0.00 | 0.00 | 104.86 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Kumar, Luke,24161 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Martinez, Cynthia,22170 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Pal, Tamara,12689 | 6846.92 | 0.00 | 2071.42 | 0.00 | 4775.50 |
| Chandra, Tina, S,13974 | 5237.73 | 0.00 | 0.00 | 2071.42 | 3166.31 |
| Ashe, Barbara,18734 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
| Fernandez, Arthur, J,22399 | 2785.05 | 0.00 | 0.00 | 2181.56 | 603.49 |
| Yuan, Tamara, E,21166 | 4909.67 | 0.00 | 2443.35 | 0.00 | 2466.32 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Luo, Dustin,17240 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Wood, Jacqueline,16705 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Kapoor, Phillip,27581 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Alvarez, Erik, M,14311 | 138.45 | 0.00 | 0.00 | 74.48 | 63.97 |
| Davis, Nicole,22957 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Beck, Cedric, L,22403 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Gray, Morgan,28307 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Li, Marshall,12687 | 6805.47 | 0.00 | 2071.42 | 0.00 | 4734.05 |
| Ashe, Misty, R,23129 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Carolyn, S,29302 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Guo, Autumn, A,14213 | 86.26 | 0.00 | 0.00 | 0.00 | 86.26 |
| He, Jessie,29094 | 796.34 | 0.00 | 0.00 | 0.00 | 796.34 |
| Lee, Richard, I,23996 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Nara, Karl,15142 | 138.46 | 0.00 | 0.00 | 0.00 | 138.46 |
| Alonso, Ricky, S,14070 | 5618.93 | 0.00 | 0.00 | 2049.10 | 3569.83 |
| Goel, Dawn,23535 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gao, Gilbert,24165 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Wang, Rosa, I,11993 | 8131.32 | 0.00 | 3374.99 | 0.00 | 4756.33 |
| Ramos, Diane, L,18300 | 64.88 | 0.00 | 0.00 | 0.00 | 64.88 |
| She, Derek,15036 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Yuan, Carl, P,24160 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Rana, Ross,25240 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Hernandez, Ebony, S,23574 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Hu, Lacey,19948 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Hernandez, Jill, L,13003 | 230.25 | 0.00 | 0.00 | 6.28 | 223.97 |
| Smith, Tina, K,19793 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Hill, Kaylee, L,11918 | 8204.99 | 0.00 | 3399.99 | 0.00 | 4805.00 |
Generated 2025-11-06 21:08:06.594 UTC