Skip to Content
avatar image
Former Member

previous months column headings

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. . .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 09, 2017 at 09:21 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 04:16 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 09:28 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2017 at 09:27 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded