   Crystal Report -- Graph with percentage
  Hey everyone.. i'm having a little trouble getting this to work correctly, and i'm curious whether anyone can help me.I have a sql table with a column "Branded".  This column is a bit (1 or 0).  I want to create a pie chart that shows the percentage of 1 values vs the 0 values.. but it doesn't seem to work correctly.  it seems to want to "sum" the values.. is there some way for me to do this? (i'm sure there is, i just don't seem to be doing it right)Thanks!   
  SELECT 100*SUM(Branded)/COUNT(Branded) AS PercentBranded FROM TableName (WHERE...)   