I have a Datamart named "SalesHistoryDM" with the following columns:
- Sku
- CustomerId
- YearMonth (Time Dimension)
- Revenue
- UnitsSold
- MarginalContributionAbs
- MarginalContributionPerc
I need to aggregate the Datamart in the logic for a specific product. I need to sum Revenue, UnitsSold, MarginalContribution and count how many customers bought the product per year.