6 Replies Latest reply: Mar 12, 2013 8:01 AM by Faisal Zahid RSS

    Comparing selected data with previous data

      Hi Guys,

       

      I have a table with Revenue numbers with dates and months. I want to compare the selected Revenue numbers with the previous Revenue numbers. (SELECTED_REV / PREVIOUS_REV)

       

      For eg. if i have selected Mar then I would like to Compare Revenue in March compared to Revenue in Feburary (MAR_REV / FEB_REV). If the user sellects March and April then it should be compared with Jan and Feb.

       

      I dont want to hard code it for any fixed duration. Any ideas?