Hi everyone

I have a calculated item in a pivot table, the formula being =IF(OR('1Q13'=0,'1Q14'=0),0,('1Q14'-'1Q13')/'1Q13'). The formula works fine for each row except for the total row where the calculation result is wrong. Also, when you click on each cell in the rows of the calculated item column the formula is displayed in the formula bar, but the row total only displays a hard number, which is wrong. Any help would be enormously appreciated!

Cheers

Derek