Webi Access to previous record of dataprovider to
hello all, i am trying to access a particular row in a data provider in my webi.
here is my table
so as the days progress, i want the previous records data. so, if the day today is 5/7/12, how can i return the Revenue Measure for the previous record, i.e. 37,342.35
thanks in advance
=Previous([Revenue]) Where ([Calendar Day]=RelativeDate(CurrentDate();-1)) to get the Revenue value for the previous day
=Previous(([Revenue]) Where ([Calendar Day]=CurrentDate()) to get the value of the previous record of the current date