on 08-23-2017 3:00 PM
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.
its not working... when i use NoFilter(sum(netsales);all) formula,it is showing all year values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try this.
NoFilter(sum(netsales);all) where( [month]=[month]-1 in report).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.