i am trying to get amount in current fiscal year 1-july-21 to 30th-june-22
count(case when "W_TIME_DIM"."FISCAL_YEAR" = '2021-22' then "C_INVOICE_DETAIL"."INVOICE_NO" end)
it is my formula but now i dont want to specify year every time. what can i do i am using OBIEE 12c