Skip to Content
author's profile photo Former Member
Former Member

Select customers who only buy from specific suppliers?

Hello,

I am working on a report and one of the requirements is to compare how customers who purchase from supplier "A" only or supplier "B" only are doing compared to those who buy from "A" and "B"

So I need a formula that will return "Supplier "A" only customer" or "Suppler "B" only customer" , or "Shared customer" instead of the actual customer's name in the report

Any suggestions on what the variable formula for this would be?

Many thanks

Adrian

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2016 at 04:34 AM

    Hi,

    I would suggest you to create two Queries

    Query1 will have Query Filter as Supplier equals to A

    Query2 will have Query Filter as Supplier equals to B


    and then merge the two queries on Customer ID and then at report level you can have it listed which customer had which supplier and which has both.


    Another option is to go with Set Operations using Combined Queries please refer below documents.


    Create a Combined Query Intersection - Business Intelligence (BusinessObjects) - SCN Wiki

    How to Find Matches e No Matches in Dimensions from 2 Queries (Union, Intersection and Difference)

    Regards

    Niraj

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.