sum negative and positive numbers - separately within a Pivot Table for Account numbers/Deals

[drom]

Hi and thanks in advance!
I haver a huge table in a tab (coming from a Macro, CSV, a FOLDER with multiple files...)

One othe Columns shows totals for account numbers
The totals are some time Adjusted by someone, so the same deal may have positive values and negative values(Adjusted)
I DO KNOW how to add a 2 new columns to show Positive values and Adjusted Values(Negatives)
But is there any other way in a Pivot Table using a Calculated filed to show positives ( kind of: =if(Total>=0;TOTAL), if (TOTAL<0;TOTAL) and name the calculated fields as

positives and Adjusted

So I can show within the Values one column for Positives and close to this column other one for Negatives ???

Please I do not want to use 2 more columns in my rowData.

I would like to know if is possible using 2 calculated Fields

ps: the negative values are preceded by other column (Adjusted by, column) So the calculated field within the Pivot Table can use kind of( if(Adjusted by=""; Positive"

if(Adjusted by<>""; Adjusted Column"

I guess you know what I am trying to do..

But I do know how to get it, rather than using 2 more columns in my rowData

 

[SpillerBD]

SUMIFS() , I now use only the SUMIFS even when I have only one criteria.
You could also use helper columns for Debits and Credits, and then just sum the Debits and Credits separately.

 

[drom]

I do not want to use helper columns/additional columns within the row data.
I Want to use within the pivot table a calculated field if possible.
Actually 2: one for positives and other one for negatives
Any help?

 

[SpillerBD]

If "Calculated Field" as Excel 2013 refers to Measures using the Data Model through the PowerPivot Ribbon. Yes.

Debits:=CALCULATE(SUM(TableName[Amount]),TableName[Amount]>0)

The desired function is not available through the ANALYZE Ribbon for Pivot Tables.