in a pivot table i want to compare actual results and budgeted figures for a half years period in a monthly split.
line 1 gives the month.
line 2 gives result in 1st column and budgeted amount in 2nd column.
my question: the total at the right side adds up all figures from line 2,actual figures and budget figures (which makes no sense in this case). I'd like to see a total for all result figures and a total for all budget figures.
how is that possible ?
thanks & happy eastern