1 Reply Latest reply: Apr 11, 2012 11:04 AM by jagan mohan rao appala RSS

    Urgent: Pivot Chart Averages

      Hi all,

       

      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?

       

      Tkx,
      Harsha