AnsweredAssumed Answered

Detail-by references disappears when using conditional algorithm based on entity.

Question asked by malav on Jan 25, 2019
Latest reply on Jan 28, 2019 by malav

Hello Team,

 

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,

 

like this, 

 

 

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.

 

like this,

 

 

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 ,

 

Regards,

Malav

Outcomes