I have a Master Dimension called Region_DIM ( Country > State > City).
I am trying to implement a chart which should update based on the dimension chose in the filter drop down ( By Country, By Product, By Customer).
I am able to implement this successfully using a pick function.
=pick(DNO, Country, Product, Customer).
But the issue is when writing an expression it does not allow to reference the Master Dimension so that my expression should look like : ==pick(DNO, Region_DIM, Product, Customer).
It looks like this is a limitation in QS , however is there a work around to this. I'd appreciate any insights/solutions.
Thanks
PR