i have one table that contain Project_number,Project_Nam
k,Amount colum. T want create another view that contain Project_number, last week amount, last month amount, last qurter amount for each Project number.
Problem is when i find out last month or last week or last Quarter amount then there is last two years data in first view. so because year i can't find out this data my Query gives last month , last week , last Qurter data for last two years.
i just need last month, last week, last quarter of current year in one view for each Project number.
Please advise .
i attached excel file that contains data in first view . From that you can analyzed Query.