Season 2 opens with pricing. Product selling price average comes from the semantic model, so it averages by month but sums at quarter and year. We fix that with the totals aggregation settings, switching row and column to average leaf. Because a native measure cannot be edited, we then create Price Forecast as a data input measure copied from it, so planners can set the price of every product by product family, channel, city, country and region.
Part of Planning · Season 2
