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.
1) All Users
2) Users Reg
3) User Login
In the table , these are the columns I have :
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 !!!!