using 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 for the relevant month.
my question: the total given automatically with the pivot table at the righthand 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
line 1 gives the month.
line 2 gives result in 1st column and budgeted amount in 2nd column for the relevant month.
my question: the total given automatically with the pivot table at the righthand 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