cancel
Showing results for 
Search instead for 
Did you mean: 

webi report filter for calmonth to derive previous month values

haripriya_pampana
Contributor
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

haripriya_pampana
Contributor
0 Kudos

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

amitrathi239
Active Contributor
0 Kudos

try this.

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