I want to write an oracle SQL query to compute monthly YTD revenue (cumulative sum) for all possible combinations of the given dimensions. There are also some months where there are no transactions and hence no revenue, in this case the previous month YTD revenue must be displayed for that dimension combination. Given table: Sample Desired output: the fiscal year
Tag: fiscal
create fiscal week number
How can I put the below logic into a format SQL Server will use to create a fiscal week number ? Answer The CASE Statement should work: