Pivot table calculated field help

New Contributor

Hi,

I want to calculate the difference between 'Average of Box Office Revenue ($)' and Average of Budget ($)' in the calculated field. I tried the formula given below in the image but the answer value seems wrong. Whats wrong? please help.The Pivot TableThe Pivot TableThe DataThe Data

0 Replies