Pivot Table Calculated Field

[IluvPivots]

Using a Pivot Table, is there a way to make a calculated field to include the net of two items.
The source data column is titled "GAIN LOSS" the rows are either a positive gain # or a negative loss #. I need to be able to pivot and graph Gains, Losses, and Net. Net is essentially the "Grand Total" column, however when graphing the pivot table the Total is excluded.

 

[Arturthemaster]

You have to set the graphic to show you the total. Do that, one graphic with sum and another with total

 

[IluvPivots]

You have to set the graphic to show you the total. Do that, one graphic with sum and another with total

Sorry, I don't follow? It needs to be one graph with 3 lines.

 

[Arturthemaster]

Sorry, I don't follow? It needs to be one graph with 3 lines.

Yes, because the excel don´t show total, only power bi do that

 

[IluvPivots]

I think I have found a solution. It is a "Calculated Item". I created a formula of Gain+Loss and it worked!