Urgent: Pivot Chart Averages

[#1]

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

[jagan]

Hi,

Use Branch as dimension and four individual expression for each week (9, 10, 11, 12) and another expression for

Total average number by using {1}.

Hope this helps you.

Regards,

jagan.