Bucket Help

[sona_sa]

Hi,

I have a field [Fiscal year/period_FISCPER], i.e nothing, It is month in the format of yyyymmm. Now I want bucket in the group of 3 months, Like 0-90, 91-180,......

Can I do the same in the same format. Also I would like to tell you 016 is December month for every year. Like 2009016 - Dec-2009.

Please help as soon as possible. Find the attached xls for ref.

Thanks.

[MK_QSL]

bucket based on what? what s the measure field ?

[sona_sa]

0 - 3 Months

4 - 7 Months

8 - 10 Months

11 - 13 Months

14 - 16 Months

17 - 23 Months

24 - 30 Months

31 - 36 Months

36 - 42 Months

> 43 Months

Will be bucket as a dimension. Measure will be Sum(Balance).

Regards,

Amit Kumar

[MK_QSL]

Can you also provide the result in excel which you are looking for?

[its_anandrjs]

In a month field what is mean for the 2014009 what is date format or you can use Class Function Here in the calculated dimension. If last two digit in the field is Month then try

Dim:-  Replace( Class(Right(Month,2),'3') ,'<= x <' , ' ' ) &'Months'

Expre:- Sum(Balance)

Regards

Anand

[kamalqlik]

Please share correct Excel.

Regards

Kamal