cancel
Showing results for 
Search instead for 
Did you mean: 

previous months column headings

Former Member
0 Kudos

I am trying to find a way to get the past 6 months as column headings based on the current month.

So for March I want the columns to be Feb, Jan, Dec, Nov, Oct, Sep

Then for April I want to automatically change to Mar, Feb, Dec, Nov, Oct

etc. . .

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi so we are using XI3? I believe the version is.

I have tried to use the formula above however I am getting an error so I don't think I am able to use the MonthPeriod function.

Any other way to get previous months?

Former Member
0 Kudos

Hi we use Web Intelligence Rich Client XI3

Doesn't look like we have the functionality to do MonthPeriod as I am getting an error message at the first ; ?

Any tips? I can send a screenshot of the error if it helps?

Former Member
0 Kudos

Hi so we are using XI3? I believe the version is.

I have tried to use the formula above however I am getting an error so I don't think I am able to use the MonthPeriod function.

Any other way to get previous months?

amitrathi239
Active Contributor
0 Kudos

what is your BO version? if it's BI 4.1 SP06 then you can use monthperiod function to get the last 6 months values.

You need to create 6 formula's to get the last 6 month values.

current month=Month(CurrentDate())

Previous Month=Month(RelativeDate(CurrentDate();-1;MonthPeriod))

similar for other place -2,-3,-4 & -5 in the formula.