Is this possible?

[#1]

I have created the following pivot table with tracks rev & exp compared to budget.  See below:

The expression for pulling the information is:

for Revenue:   =sum({$<Type = {'Revenue'},TC={12},CalYear={2014}>}[Transaction Amount])

for Expenses: =sum({$<Type = {'Expenses'},TC={11},CalYear={2014}>}[Transaction Amount])

Is it possible it have both the Revenue and Expenses in the same expression? 

Below is  what I need this to file to look like:

(I have to export this to excel in order to pull revenue and expenses into a single column)

[JonnyPoole · Accepted solution]

You can try change an expressions to conditionally display revenue or expense using something like this....

if( Type='Revenue',

     sum({$<Type = {'Revenue'},TC={12},CalYear={2014}>}[Transaction Amount]),

     if( Type='Expenses', sum({$<Type = {'Expenses'},TC={11},CalYear={2014}>}[Transaction Amount]) )

)

[#3]

Thank you very much!