FP11 Chart - combining 4 quarters into 1 bar
I am paid royalties quartlery but the thing is I want to add the four quarters up and display this total on a chart as yearly earnings instead of quarterly but no matter what I do I always seem to end up with 4 quarters showing. I have boxes in my database that contain the sum of the quarters for each year and show them as a yearly total but I have no idea how toget these to appear in a chart. They always seem to split it back up into 4 quarters.
Any help greatly appreciated as I have been pulling my hair out over this!