Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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]) )
)
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]) )
)
Thank you very much!