I have a field with a list of various foods and drinks. I am then creating a calculated field based on these values to define them specifically as either Food or Drink. I then need to compare individual foods or drinks against overall figures. e.g in the chart below I am trying to compare Apples which is the red column. I am guessing this is grouped in with food as Apples is defined as a Food in the calculated field.
Is there any way to get the numbers showing as distinct columns rather than two being grouped together?
Failing that is there anyway to get rid of the 0,0 and -1 below the column titles?