Power pivot display calculated columns for each month

[avi_samucha]

Hello,

I have a power pivot model with budget table, forecast table and keys table.
Forecast table columns: Data Type, Manager Name, Client Name, Period, Amount, Month, Year, Key (Manager A_Client A_Month_Year)
Example of table row: "Forecast", "Manager A", "Client A", Jan-17, 100, 1,2017, Manager A_Client A_1_2017

Budget table columns: Data Type, Manager Name, Client Name, Period, Amount, Month, Year, Key (Manager A_Client A_Month_Year)
Example of table row: "Budget", "Manager A", "Client A", Jan-17, 200, 1,2017, Manager A_ClientA_1_2017

Keys table columns: Manager Name, Client Name, Month, Year, Key (Manager A_Client A_Month_Year)
Example of table row: "Manager A", "Client A", 1,2017, Manager A_Client A_1_2017

Model connect Keys table to Budget & Forecast in Key column.

My problem:
I need to display the following pivot:
Manager Name, Client Name, M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11,M12, Total Budget, Total Forecast.

Example:
Manager A, Client A, 300, 0,0,0,0,0,0,0,0,0,0,0,200,100

M=month.
In 1,2,3 ... columns I need to display total budget & forecast for this month.
I know to display the months data in rows. How can I do it in columns?
When I add month to pivot columns I got 12 columns for budget and 12 for forecast and I wish to get 1 column for each month
and additional 2 columns for total budget & total forecast.

Can you help me ?

Thank you for your help