Skip to Content
0

Display Month wise data without month in the Webi report layout

Nov 11, 2016 at 08:35 AM

70

avatar image
Former Member

Hi,

I've to display the sales by month using a C_Code in a vertical report without displaying the month in the report layout,

The layout is provided below Where N is last month October (Considering today is November 2016), N-1 is September & so on.

C_Code | N | N-1 | N-2 | N-3

123 |100 | 70 | 50 | 25

345 | 90 | 40 | 60 | 75

How can this be achieved ?

I tried using the formula, Sum(Count) Where (C_Month=Last_Month) but it displays for all the month in rows. I want it in the above format. Any help would be great.

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

1 Answer

Jyothirmayee A Nov 17, 2016 at 09:57 PM
0

Hi,

Can I assume C_Month is current month and Last_Month is Currentmonth -1?.

above formula never be true. Current Month never be equal to Last-Month (November = October).

If you are trying to get the currentmonth| CM-1|CM-2 then try formula.

CM-1:

=Month(RelativeDate(CurrentDate();-(DayNumberOfMonth(CurrentDate())+1)))

CM-2:

=Month(RelativeDate(CurrentDate();-(DayNumberOfMonth(CurrentDate())+2))) and so on....

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded