3 Replies Latest reply: Sep 25, 2014 8:08 AM by Eddie Morah RSS

    Inter record functions in chart to work on selection

      I have a pivot chart, where I have used inter-record function "Above"  and "Before" to compare and get new values. But, I ran into a problem here. Whenever, I select a specific value on a chart, values in expressions derived using these inter-record functions are becoming nulls. I know its because they no longer have values before or above them. But, is there any way I can get these values to show upon selecting a specific value?


      Scenario is (Just an example). My chart is little complicated and has totally different expressions than these.

      Years as dimension horizon and Sum(Sales), Before(Sum(Sales)-Before(Sum(Profits))+Sum(Expenses)