Financial Year Set Anaylsis

[#1]

Hi All,

I am trying to write a Set Analysis code for Indian Financial Year i.e Apr-Mar cycle

I have segregated my Date column in Financial Year and Months

I have also created the Variables that will hold values for Current,Previous Year and Current,Previous Month

However, I am not able to get the correct Set Analysis syntax for the requirement.

Please see the attached qvw.

Thanks in Advance.