Skip to Content
avatar image
Former Member

Restrict results in webi report based data from multiple columns

Is it possible to create a variable to eliminate or keep data based on data from multiple columns.

For Example: Company XYX has two locations, 76381 and 76198, and receives a discount at each. So I would like to eliminate that CUSTOMER from the results. Same with the other Customers highlighted Yellow. However, Customer 5360 has multiple locations but only receives a discount at one of their locations, 77999. That should be included in the results. As well as Customer 9956 who has two locations and only receives a discount at one, 73901. I would like to identify those Customers with multiple locations and is not receiving a discount at each location.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 13, 2016 at 08:17 PM

    Hi,

    Did you tried?,

    =Customer where (Discount = "WWH")

    above formula will display Customer with no discounts and pull in Location, ID and company name.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2016 at 11:20 PM

    Thank you Jothi for your response. My apologies if this is confusing. Yes, that will give me all of the customers with WWH but they could also have STX discount at the same location. I want to exclude those Customers that have both WWH and STX at the same location and only identify those with just WWH and no other discount. So I want to exclude those customers in yellow because they have both discounts at the same location.


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2017 at 02:17 PM

    Hi

    you will need to define some variables to check your logic,

    for instance your first logic (twice -STX for one customer)

    variable: count STX

    change state by your discount and massuchesetts by STX and color by customer

    now you will know how many STX per customer exists, you can filter the table count stx <2

    Add comment
    10|10000 characters needed characters exceeded