[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 60 > < TAKE 30 >
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Zhao, Crystal,25906 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Romero, Jimmy,27704 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 2181.56 | 1155.48 |
| Gill, Alberto, P,17733 | 4758.24 | 0.00 | 3578.27 | 0.00 | 1179.97 |
| Carlson, Tanya,16183 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Madan, Stanley,19602 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Rodriguez, Ruben,12589 | 2665.06 | 0.00 | 0.00 | 2049.10 | 615.96 |
| Liu, Susan,18718 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Williams, Madison, J,21198 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Johnston, Tamara, H,18492 | 218.26 | 0.00 | 0.00 | 0.00 | 218.26 |
| Gonzalez, Ivan, C,19625 | 52.77 | 0.00 | 0.00 | 0.00 | 52.77 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Rana, Stefanie, K,19616 | 5279.26 | 0.00 | 3578.27 | 0.00 | 1700.99 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 0.00 | 806.76 |
| Raji, Carl,19595 | 6095.08 | 0.00 | 3578.27 | 0.00 | 2516.81 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 3.99 | 79.98 |
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 0.00 | 2443.35 | 2568.92 |
| Shan, Gregory,20614 | 6035.60 | 0.00 | 3578.27 | 0.00 | 2457.33 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 0.00 | 2049.10 | 3633.80 |
| Jiménez, Darren, W,28931 | 166.28 | 0.00 | 0.00 | 0.00 | 166.28 |
| Ma, Omar, I,15232 | 39.97 | 0.00 | 0.00 | 0.00 | 39.97 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Munoz, Sheila,27488 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Sanz, Gerald, J,17060 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Suarez, Gina,20248 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
Generated 2025-12-21 06:24:26.339 UTC