[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 SKIP 2000 < SKIP 1000 > < TAKE 1000
37 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raheem, Bethany, L,21965 | 99.47 | 0.00 | 0.00 | 0.00 | 99.47 |
| Gonzalez, Roy, M,13040 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Lopez, Toni, K,25140 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Mr., Smith, Leonard, J.,27972 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| Carlson, Marie,29311 | 603.96 | 0.00 | 0.00 | 0.00 | 603.96 |
| Jai, Gregory,16342 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Munoz, Marvin,14680 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Huang, Willie, C,28133 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Rodriguez, Toni, J,25251 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sharma, Tracy,17731 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Romero, Clinton, F,28132 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Suri, Rachael, J,18279 | 162.02 | 0.00 | 0.00 | 0.00 | 162.02 |
| Black, Tommy,24376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Rana, Terrance, M,28134 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Vance, Henry,27986 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Subram, Ronald, P,27733 | 157.29 | 0.00 | 0.00 | 0.00 | 157.29 |
| Pal, Omar,27714 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Sanz, Sabrina, A,19650 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Raje, Donna, A,20607 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Lopez, Ross,18443 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Alvarez, Arthur,24892 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Hu, Edwin,24240 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Arthur, Joel,27701 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Subram, Ivan, A,26147 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Washington, Sydney,28924 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Madan, Brandy, A,27687 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Lopez, Dominic, B,27590 | 1189.46 | 0.00 | 0.00 | 0.00 | 1189.46 |
| Munoz, Teresa, R,27712 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Mehta, Pamela,22005 | 135.46 | 0.00 | 0.00 | 0.00 | 135.46 |
| Ruiz, Alfredo,21975 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Kumar, Gilbert, L,28140 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| _SUM | 9051988.22 | 188094.03 | 2486908.01 | 2218695.11 | 4158291.07 |
Generated 2026-01-04 13:37:42.733 UTC