pivot table for analysis

the client wanted to answer these questions with the excel sheet

what is the average budget for every genre?

what is the average revenue for each genre

which genre is the most profitable