Hello All,
I have table sales where I have daily ,Weekly and monthly sales Data.
The columns are TrendType,Date and Sales
So here my requirement is I need to create a query on my table to calculate the last 12 months, 12 weeks and last 30 days along with MTD,WTD and QTD data.
So here the trendtype for MTD should show as monthly, trendtype for WTD should show as Weekly and trendtype for QTD should show as Quarterly as these comes when we select the respected trend types in our reports.(Ex: if I select monthly then I can see last 12 months and MTD also)
Could any one please help how to do