1 Reply Latest reply on Dec 18, 2017 12:42 PM by Jim Dehner

    Show customers with similar sales when a customer is searched

    Fisseha Berhane

      When I search a customer, I want my bar graph to show the searched customer and other customers who are within $1000 sales value as the searched customer. For example, if I searched for customer "X", I want my graph to include customer X and other customers who have sales ranging from customer X's sales -$1000 to X's sales + $1000. How can I do this? I have attached a workbook which contains a bar graph and where I can search a customer.

        • 1. Re: Show customers with similar sales when a customer is searched
          Jim Dehner

          see the attached

           

          There are probably other solutions - this one uses a fixed formula for sales

           

            note in your real data you may need to modify the formula for the dimensions that you use

           

          then the min and max range for sales are

           

              

           

          then a filter is based on the min and max - set on filter shelf and set = True

           

          It will return this

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.