BusinessObjects Board

Compare a single value of a dimension against the rest

building reports desktopintelligence
#1

Hi everyone,

I have been searching for a solution for a long time now, but wasn’t usccessful.

Basically what I am trying to do:
I have a table with TRADE_ID, CUSTOMER, VALUE, PRODUCT
I would like to be able to select a single COMSTOMER in an input control and then be able to see the sum of the customers VALUEs vs the total sum of VALUEs. I achieved that by creating a variable noFilter(Sum(VALUE)), which is showing me the total value of all CUSTOMERs combined.
But the issue is: I can’t add a second input control, e.g. PRODUCT. If I select a single product, the value for the selected customer is correct, but due to the noFilter variable, the sum of VALUEs for the rest remains the same.

I tried all kind of stuff, but none worked:

  • Create a variable Copy of CUSOMER for the input control and create a Selected Customer VALUE: sum(VALUE) Where (CUSTOMER = Copy of CUSTOMER)
  • Create a second query and calculate the customer value like this: sum(VALUE) where (Query1.CUSTOMER = Query2.CUSTOMER)
  • Created a Detail of CUSTOMER for the input control

I hopy you understand my issue.

Best Regards :slight_smile:

degude (BOB member since 2018-03-28)

#2

try this one:

=max(NoFilter(Sum(VALUE)) ForEach )

bonotatsujin :taiwan: (BOB member since 2017-12-20)