I need help representing the averages in a pivot chart. I have four dimensions (Branch, Week, Dimension3, Dimension4) and one measure (number of customers) in my raw data. I am creating a pivot chart with two dimensions (Branch and Week). I want to create another pivot chart in which i want to show only 4 four specific weeks (for example 9,10,11,12), but i still want to retain the total average number. Find attached the excel which shows the existing and desired pivot charts.
Any ideas on how this can be done?