I have a movie data set and a I have Revenue and budget for all the movie categories, I created a pivot chart in excel with Average movie revenue and Average Movie budget for different categories like Action, comedy etc, Now I want to calculate the Average profit by subtracting the Average revenue from Average Budget But When I do so by creating a calculated field I am getting weird kind of results please if some one can help ????
I am also attaching a screenshot for your consideration.
Bookmarks