Skip to Content
avatar image
Former Member

webi report filter for calmonth to derive previous month values

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 23, 2017 at 02:57 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2017 at 07:46 AM

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

    Add comment
    10|10000 characters needed characters exceeded