Show same column as two in the table without summarizing

Hi folks,

How do I show same table column as two columns with different filtering in the table visual? For example if I have positive amounts for income, and negative amounts for expense in the same column in the Sales table, how can I show Income in one column and Expense in the second column in the table visual? Trying to add Sales(Amount) column twice into the table visual does not allow me to filter one column as Amount>0 and the other as Amount<0. I also need amounts not summarized. Here's an example:

Initial table                      Expected result

Date    Amount                       Date    Income      Expense
1/1        100                        1/1    100
1/2        -20                        1/2                 -20
1/3        -30                        1/3     80          -30
1/3         80