Insert calculated row in Pivot table

[arnesbeganovic]

Hi team,

here is the issue that I have: I read data from multidimensional cube and there is this hierarchy:

 

[arnesbeganovic]

Hi team,

here is the issue that I have: I read data from multidimensional cube and there is this hierarchy:

sorry about this. I do not see edit button so I will write my question in next post

 

[arnesbeganovic]

So,

I have following hierarchy:
+Revenue
+Costs
+SubCost1
+Subcost2

Pivot table allows me to make total for whole table. It will be profit/loss. BUt now I received requirement to make it like this:

+Revenue
+Costs
+SubCost1
TOTAL UNTIL SUBCOST1
+SubCost2
TOTAL

I tried to change cube hierarchy without sucess, I tried to combine two pivot tables without success because I loose this + sign. I can not insert row inside and calculate Revenue - SubCost1 (which is eventualy what I need to show).

I have a kind a solution outside pivot table with formulas where I summarize if field is Revenue and SubCost1.

Is there any possibility to put calculation inside Pivot table?