Hi Excel enthusiast.

Appreciate if you can help me with this simple thing, I guess?

I'm sorry that I cannot include the file here as it is not my right to do so, however, I will try to make the explanation of the question crystal clear, but still sorry for the confusion that might occur as my English is my second language.

--------------------------------------------------------------------------------------

First, I do have an excel table with 7 columns following this format as the source:
Capture.JPG

Second, I add that table to data model.

Third, I would like to make a pivot table, but because I already added it to data model (for later/other pivot table from multiple sheet purposes), so insert the pivot table from the data model.


The display of the pivot table that I got for now is shown by this picture
Capture1.JPG

And here is the arrangement of the Pivottables field
Capture2.JPG

So my question is: "Is there any way to merge or to make the the additional column of outcome and income become one?"
Somehow I think Dax(Measurement) can do it, but I dont know the right formula to do so, hehehe.
Hope you can help me solve this trivial matter. Thanks you in advance


nb: Cashflow status value only 2: Outcome & Income.