Skip to Content
0

previous months column headings

Mar 08, 2017 at 08:19 PM

48

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

AMIT KUMAR
Mar 09, 2017 at 09:21 AM
0

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.


untitled.png (8.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Simon Taylor-Allan Mar 09, 2017 at 04:16 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Simon Taylor-Allan Mar 09, 2017 at 09:28 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Simon Taylor-Allan Mar 09, 2017 at 09:27 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded