title: Pulling data based on year, month, quarter
body: <p>I have an input and output table as below. The input table is updated everyday. I need to find the value of the previous financial year, Previous month, previous quarter. I have written the query below for finding the previous financial year value. </p>
  
  <p>case when ReportFinancialYear = 'FY19' then Value else null end as previous_financial_year_value</p>
  
  <p>But i want to use ReportFinancialYear = current Financial Year-1, something like this. The similar formula for the remaining. Can anyone please assist.</p>
  
  <p><a href="https://i.stack.imgur.com/Txwd1.png" rel="nofollow noreferrer">enter image description here</a></p>