Hi ,
I had a crosstab report as below :
Year Region Sales Amt
2008 2 100
3 200
4 150
5 50
6 300
2009 2 500
3 20
4 750
5 950
6 800
2010 2 580
3 600
4 450
5 250
6 300
How do I create 3 pie chart for 3 years (2008,2009,2010) with Region as the pie slice.
Put the [Year] in Categories(pies), [Region] in Series(pie slices) and [Sales Amt] in Default Measure.
It will create pie chart for each Years.
Hope should help?
Thanks
Prit
Hi Prit,
It's working...
Many thanks.
Joe