Our company Financial year cycle starts from Oct to September.
I have fields/columns from Oct to June as
MthData11 for Oct ,
MthData10 for Nov,
MthData9 for Decand so on till
MthData for Sep.
For July, Aug and Sep data is "0". Now I need to build a logic such that when I reload the dashboard every month MthData2 will be my current month (July) and MthDate3 (June) will be my previous month and MthDate4 (May) will be my Previous to Previous month.
(When I reload the dashboard in September MthData will be my currentmonth and MthData1 is Previous and MthData2 is PrevtoPrev)