3 Replies Latest reply on Oct 6, 2016 8:35 AM by Charles Foley

# Dynamic Paramaters? Any other way here?

I have attached the workbook in question.

The end user was adamant about having the top graph.  It calculates a customer percentile rank compared to other customers.  This will only show the selected customer as an orange circle.

Someone else helped me figure that out with the following formula:

LOOKUP(ATTR( [Customer Name] = [CustomerParam]), 0)

or

LOOKUP(ATTR([Customer Name]), 0)

Works perfectly!

BUT!

My customers are a two level heirchy.   We have 300 Parent Companies and 26k stores underneath them as customers.

I would need my filter/paramater to be able to start off at a parent company and then the filter/paramater would change when the lower level was selected.  And then you could select from the individual rooftops.

Is this possible?  Ive tried for a week and nothing

• ###### 1. Re: Dynamic Paramaters? Any other way here?

Charles, just to make sure I'm following you here, you want to select a company from a dropdown list of 300 companies and once you do that you want another dropdown to filter to ONLY the customers/stores within that selected company? If yes, I assume you have a dimension for company and another for customer/store? If no, can you please clarify. Thanks.

Ken

• ###### 2. Re: Dynamic Paramaters? Any other way here?

Dynamic Parameters have been answered in this post  . If this answers your question do mark you question as "Answered" so that it does not remain open and shows up in the list of "unanswered question" .

• ###### 3. Re: Dynamic Paramaters? Any other way here?

kenneth, it s organized as follows:

Parent Company, Customer Name, Customer Level(Parent Company or Store Level)

so, if it was a parent company, the customer name would also be the same as the parent company and the customer level would be parent company if that makes sense