[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 15 >
15 items
DimCustomer.Name+','+DimCustomerIdId | _SUM | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
He, Amy,22411 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
Chande, Arturo, H,14860 | 67.26 | 0.00 | 0.00 | 39.98 | 27.28 |
Lopez, Kari,15235 | 190.89 | 0.00 | 0.00 | 0.00 | 190.89 |
Suarez, Orlando,11121 | 58.16 | 0.00 | 0.00 | 0.00 | 58.16 |
Kapoor, Ruben, D,11109 | 8245.01 | 3374.99 | 0.00 | 2476.96 | 2393.06 |
Lin, Clarence,29069 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
Jimenez, Felicia, L,11075 | 8068.03 | 3374.99 | 0.00 | 2294.99 | 2398.05 |
Xie, Michele, M,15039 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 32.27 | 197.98 |
Perez, Dominique,12344 | 68.70 | 0.00 | 0.00 | 44.21 | 24.49 |
Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
Patel, Rachael, G,13640 | 71.25 | 0.00 | 0.00 | 32.27 | 38.98 |
Ross, Mya, E,27715 | 1147.77 | 0.00 | 0.00 | 0.00 | 1147.77 |
He, Jon, L,14262 | 5652.54 | 0.00 | 0.00 | 2071.42 | 3581.12 |
Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
Generated 2024-09-20 06:28:49.129 UTC