Skip to Content
0

webi report filter for calmonth to derive previous month values

Aug 23, 2017 at 02:00 PM

53

avatar image
Former Member

hi all,

we need to develop webi report, following we need to.

1. we created filters month and year ,derived from calmonth.

2. by default the filter should select current month and current year

3.derive netsales for previous month

I have derived month and year from calmonth with monthnumberofyear and year functions. and added in filterbar. but am unable to set default current month and year.and also applies NoFilter function NoFilter(sum(netsales);all) but it displays all year values.

when i write a formula NoFilter(sum(netsales);all) where( [month]-1=[month]). it is displaying null values.when i hardcode Month =8 then it is showing values.

Source is bex query but user doen't want to refresh the report.

Thank You in advance.

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

2 Answers

AMIT KUMAR
Aug 23, 2017 at 02:57 PM
0

try this.

NoFilter(sum(netsales);all) where( [month]=[month]-1 in report).

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 28, 2017 at 07:46 AM
0

its not working... when i use NoFilter(sum(netsales);all) formula,it is showing all year values.

Share
10 |10000 characters needed characters left characters exceeded