The situation is that I have a list of products and how much we sold of each
one in 2006. I want to take the top 10 products of the list and put them in
a pie chart to show how much of the TOTAL of all products they are. A
percentage of the total if that makes more sense.
The problem is the pie chart uses the total of the 10 products instead of
the total of ALL products. Can anyone tell me how to do this? I'd greatly
appreciate it.
Thanks
--
jlc