Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
Not really sure what you are looking for. Could you explain a bit more? What if you use expression:
Sum({<Supply_Chain=>} Sales) ?
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