An analyst wants to create a bar chart showing the total sales for each Sub-Category.
They also want to display a reference line showing the average sales for the corresponding product Category for comparison.
The view contains [Category] and [Sub-Category] on the Rows shelf.
Which calculation will correctly compute the average sales at the Category level, regardless of the Sub-Category detail in the view?
