0 Replies Latest reply on Jan 30, 2013 8:50 AM by dora iyer

    radio button to aggregate data

    dora iyer

      Hi,

       

      This is my requirement and I don't know how to do it.

         as per the requirement, I need to have 3 radio button on the dashboard.

      Radio button:

      1) All Users

      2) Users Reg

      3) User Login

       

      In the table , these are the columns I have :

      Table A:

      processingDate

      week1count

      week2count

      week3count

      isUserFlag

       

      This isUserFlag will have 2 values 0 and 1. 0 means Users Reg and 1 means User Login

       

      if the user selected the radio button "Users Reg", then I have to select the rows from the table where the isUserFlag=0 and if the User selected the radio button "User Login", then I have to select rows from the table where the isUserFlag=1.

       

      But if the user selected the radio button "All Users", Then I need to select all the rows from the table and also sum up the week1count, sum up the week2count so on.

       

      How can I do this. Any help is highly appreciated !!!!