It was our thought to use custom fields if possible to achieve the variance and percentage result as per below.
The headings need to be customised as well
Description August September October SO Forecast 1928 1985 2565 Sales History 1184 1768 1774 Variance (Qty) (744) (217) (791) Result % 61% 89% 69%
In regards to the three numeric columns they are based on data from one SQL table column. The data in these columns is displayed in by month which is also taken from the date stored in a SQL Table field.