Formula for omitting input filter results

building reports webintelligence legacy
1

Hi all:
Please bear with me; I’m really new at this. I’ve been reading alot about calculation contexts but I can’t seem to nail this.

I’m creating a Webi report for the sales staff, with three input controls:

  • product
  • quarter (of the year)
  • country

What I need is to create a variable that gives me a total of each salesperson’s sales, adding up all products (no matter what product is selected in input control) BUT in accordance with the quarter(s) selected in the input control.

I’d really appreciate any help anyone can offer.

sauki (BOB member since 2013-10-03)

2

nofilter() will ignore filters, but you can’t choose to keep some or one all or nothing.

erik.stenson :us: (BOB member since 2012-07-30)