Calculate sum of sales for the week in SQL Calender
Hi,
I have used a SQL Calender where i am displaying 5 sales columns for each weekdays( MON - FRI).
the weekdays data is coming in each cell of the day in Calender. Now On SAT of the Weekend I have to calculate the sum of the sales for some colums and for rest of the columns i have to used some formula to calculate the value.
This things i have to show on each weekend ie on SAT for the week.
I am not able to display the sun and calculated value in SAT cell of Calender for each week.
So Please help.
Thanks
PK