Monthly data to select with respective column

[Anonymous]

Hi all,

Mothly info

[sunny_talwar]

May be like the attached

=Year([KPI Date])-1

& '/' & Year([KPI Date])

I suggest creating this in the script....

[Anonymous]

Thanks - but how ever i would be more interested to get the current fin year than all the years in the filter
and also if i click on 2017/2017 it shows only 2017 data excluding 2016 data
FilnYear Filter box should have only 2016/17 - field( next year 2017/18, later 2018/19...)

Would you please suggest

[sunny_talwar]

I am not sure I completely understand... You need 2017/2017 or 2016/2017?

[Anonymous]

sorry it was my typo in the last post:

I need 2016/17 in the finyear list box and if i select that the data should have only for 2016/17 data- excluding all the years selections

Hope its a bit better now

[sunny_talwar · Accepted solution]

May be like attached

[Anonymous]

thanks - but cant we done the same in the application side ?

[sunny_talwar]

May be using triggers, but why do you want this to be done on the front end? It would be complicated, whereas script based solution is simple and efficient?