Calculated Fields in OLAP CUBE's

Question

Since the calculated fields options in my OLAP Cube reports are grayed out, I found a way to add the calculations needed....with one small issue. The data is coming from our financial system (Dynamics AX). I set up some calculated measures and then added them from the Field List into my pivot table. The only problem is that I can't get them to report only on the totals rows. They repeat after each section by the year. So I hid the columns I didn't need. Not that it matters to me, but the columns are gone now that I hid them and they won't unhide.  Any advice?

I want to show it like this:

Revenue Budget	Revenue Actual	Total Budget	Total Actual	Total Difference	Total % Difference
2017	2018	2017	2018
$     <br>(12,989)	$                 <br>-	$                 <br>-	$                 <br>-	$     <br>(12,989)	$                <br>-	$           <br>(12,989)	0%
$   <br>(209,847)	$   <br>(209,847)	$   <br>(209,847)	$     <br>(17,487)	$   <br>(419,694)	$ <br>(227,334)	$         <br>(192,360)	54%
$                 <br>-	$                 <br>-	$          <br>(250)	$                 <br>-	$                 <br>-	$         <br>(250)	$                  <br>250	N/C

Prior to hiding them there was a total for 2017 BvA, 2018 BvA and then the % for each.......

Answer 1

I would suggest that you should post simultaneously to PowerBI forums also as this will increase chances of getting the fast answer to this query. So, your question will be on three forums - This and Technet and PowerBI Community. Experts on these 3 forums will assist you giving you wider reach.

Technet PowerBI Forum - https://social.technet.microsoft.com/forums/en-...

PowerBI Community Forum - http://community.powerbi.com/t5/Forums/ct-p/Forums