3 Replies Latest reply: Oct 4, 2012 9:23 AM by Fra Car RSS

    comparing data selected year to year previous to selected, selected month to month previous to selected,selected quarter previous to quarter previous to selected

      Hi there,

      i have a master calendar  to use to compare values through a period of time.

       

      I have 3 listboxes

      The first contains the years: 2010,2011,2012

      The second contains the Quarters with the corresponding year:

      Q1-2010, Q2-2010,Q3-2010,....,Q3-2012

      The third contains the Months with their corresponding Years:

      Jan-2010, Feb-2010, Mar-2010,.....,Jul-2012

       

       

      I have a table in which i want to display the count of a transactions database and the sum of these transaction value, according to the selected listbox, of the selected value versus the one in the previous year,eg if Q1-2012 is selected i want to compare it with Q1-2011 or if Mar-2012 is selected i want to compare it with Mar-2011, and the previous one, eg  if Q1-2012 is selected i want to compare it with Q4-2011 or if Mar-2012 is selected i want to compare it with Feb-2012.

       

      Only one selection at a time should be permitted form one listbox.

      The user must not be able to select  eg Q1-2010 And Jan-2010 . Only one of them.

      Also i would like to incorporate an if statement that will show the desirable result according to the selected option.

       

      Thanks in advance for any answers.