I have a Dataview Layout as this
Under axis I have these entities:
and under data i have these:
Content D, E and F have References by (div-dept, sample image shown below)
All are cube and algorithm contents,
For F Content , i have entered an algorithm (E-D) and under references i have detailed it by Different divisions,
i am getting a proper dataview, like this
Now what i want is for F algorithm as described above, if rows are Cost of Sales or Exp Expense is should calculate (D-E) instead of (E-D).
I know this is possible by applying entity in layout and using conditional algorithm on it but when i do that the Var column and References detail-by Column (by division) disappears, and i can just see the Actual and Budget columns.
and here is the resultant data-view
is there any work around to fulfill my requirement, is there any functionality i am missing out ?!
please guide ,