0 Replies Latest reply on Apr 27, 2018 12:48 PM by user652652

    Add a new calculated row-should not impact grand total in OBIEE.

    user652652

      Hi experts,

       

      We have a report with waterfall graph with fixed dimensions like A,B,C,D.

      And in order to start the last row as total(A+B+C+D) from 0 on X axis,we implemented as grand total in OBIEE(OBIEE internal Grand total). And did not do any calculation. If we derive it(do calculation), it will not start from 0 on x axis.

      Now we want to add one more row E(B+C+D) in this ,but our grand total should not impact i.e. it should always be(A+B+C+D) not (A+B+C+D+E). How we can achieve it in OBIEE.

       

      As you know we can't derived grand total,because if we drive it (calculate it),it will not start from 0 on x axis.

       

       

      Thanks for your help.