Range Filter in Multibox

[Anonymous]

Hi Team,

I have a multibox which is showing range value like Dec16-Nov17.

I want to convert it into a single filter as 2017 for Dec16-Nov 17 and 2018 for Dec17-Nov18 and so on.

How can I achieve this.

Please help me on this.

Thanks.

[Anil_Babu_Samineni]

Are you looking for Fiscal Year

[Anonymous]

Hi Anil,

This scripting is done on the extraction side on the link you have attached.

I have already a long script on extraction part and i want to achieve this on set-analysis.

I am already getting the value as Dec16-Nov17 from a field u can call RangeYear.

How can I achieve the year only 2017 by using that field on Set Analysis.

Could you please help on it.

Thanks.

[Anil_Babu_Samineni]

Thus, Sum({<RangeYear = {'$(=Max(RangeYear))'}>}Sales) ​not returning for you?

[Anonymous]

It is not working for me.

I am using a multibox in which I have used a field called TDimMonth.RangeYear which is returning value Dec16-Nov17, Dec15-Nov16 and so on.

Instead of this value I want to get Year - 2017 only.

Please help.