[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1186 > < TAKE 31 >
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ma, Bianca,19798 | 128.44 | 0.00 | 0.00 | 0.00 | 128.44 |
| Gao, Arturo,28714 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Cai, Gilbert, J,18256 | 98.96 | 0.00 | 0.00 | 0.00 | 98.96 |
| Andersen, Mitchell, H,25026 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Subram, Martin, S,19590 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Madan, Rachael, R,16486 | 76.97 | 0.00 | 0.00 | 0.00 | 76.97 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| White, Kayla,26424 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Shen, Corey,26739 | 61.97 | 0.00 | 0.00 | 0.00 | 61.97 |
| Rubio, Marie, V,20618 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Ye, Franklin, L,13952 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Zhu, Colin,19973 | 83.44 | 0.00 | 0.00 | 0.00 | 83.44 |
| Carlson, Eddie,23347 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zheng, Jamie, L,22156 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Gary,27482 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martinez, Abby,29333 | 54.98 | 0.00 | 0.00 | 0.00 | 54.98 |
| Nelson, Kaitlyn, J,24276 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Romero, Jimmy,27704 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 0.00 | 1288.31 |
| Zhou, Stacey, L,21374 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| She, Lindsay,29456 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Gill, Orlando,21360 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Pal, Wayne,19764 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Shan, Eric, L,26771 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Goel, Shawna, L,29332 | 165.28 | 0.00 | 0.00 | 0.00 | 165.28 |
| Alvarez, Tyrone, K,27693 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Simpson, Sharon, L,25123 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-23 07:21:04.037 UTC