How to restrict Field in chart having same values with different name fields

[Lakshman_1031]

Hi All,

I have one table and in that having duplicate field names like

Supply2 and Supply_chain having values like Asia,Gulf and States .

I have one chart and in that Supply2 having Dimension.

I want to restrict Supply_chain selection for that  i have used 

Sum({<Supply_Chain=>} Sales)

and 

Sum({1<Supply_Chain = $::Supply_Chain>} Sales)

But it is not working Please suggest me how to avoid Supply chain selections in chart with out using alternative state, Because Supply_chain selections reflected in entire dashboard.

Please see the below example for your reference.

If possible please suggest me how to achieve this scenario.

Thanks  &  Regards,

lakshman   

[jonathandienst]

I am not sure what you are trying to do here. The model looks OK, although I would prefer not to have two fields containing the same information. 

If you want to limit Supply_Chain to match the values in Supply2:

{<Supply_Chain = P(Supply2)>}

Although this will do nothing if Supply2 and Supply_Chain are in the same data table.

[Lakshman_1031]

Hi Jontydkpi,

Thanks for your replay.

I have tried {<Supply_Chain = P(Supply2)>} but it is not working.

My problem is if i select anything in supply_Chain it won't effect in bar chart and remaining filters will effect.

But i have used {<Supply_Chain = P(Supply2)> it is effected my chart.

please suggest me how to achieve this scenario.

Thanks & regards,

Lakshman

[Lakshman_1031]

Hi Jontydkpi,

Thanks for your replay.

I have tried {<Supply_Chain = P(Supply2)>} but it is not working.

My problem is if i select anything in supply_Chain it won't effect in bar chart and remaining filters will effect.

But i have used {<Supply_Chain = P(Supply2)> it is effected my chart.
please suggest me how to achieve this scenario.

Thanks & regards,

Lakshman

[tresesco]

Not really sure what you are looking for. Could you explain a bit more? What if you use expression:

Sum({<Supply_Chain=>} Sales)        ?

[Lakshman_1031]

Hi Tresesco,

I have one table in that having fileds like Supply2 field having values like Asia, Gulf, States and Supply_chain having Asia1, Gulf 1, States 1.

I have chart and in Dimension having Supply2.

I have filters like Supply 1,Supply 2 Category and Supply_Chain.

My problem is if i select Supply_chain it won't effect in bar chart and remaining objects will effect based on the Supply_Chain and other filter selections,

and bar chart will effect other filter selections except Supply_chain selections.

I tried in expression Sum({<Supply_Chain=>} Sales). 

Please see the below example for your reference.

Please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman