making more than one pie chart for each group

[hatemgamil]

hi all
lets say i have a report that looks like this

customer_ID customer_Name Order_Amout Order_Date
Group #Customer_Category(VIP)
1 xx 5 8/1/2010
2 yy 4 7/1/2010
3 zz 8 9/1/2009
4 ww 9 8/9/2009
Group #Customer_Category(Normal)
5 aa 8 9/1/2010
6 ss 9 8/9/2009

i want to make 2 pie charts for each year (2009,2010) that shows the percentage of VIP Customers and Normal Customers the first pie for the where year(Order_Date)=2010 and the second that shows the percentage where(Order_Date)=2009

any suggestions
thnx

 

[IanWaterman]

Bcause you have not grouped data by Year I think the only way to do this is to add a subreport using the same data set and then grouped by year, which has the two charts you want.

There might be an easier way, but I have not found one

Ian

 

[hatemgamil]

thnx IanWaterman

i can do a group by OrderDate For Each year or using a formula to group by it Year(Order_Date)

then if i did that
whats next

 

[IanWaterman]

Then group by category.

Add summary to the category group and check the express as %age of Year in the group dialog box.

Then add chart, select group, in place chart select header for year group (from drop down).

Should already default to summary and percentage.

Ian