Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to reference dimension value in measure calculation,
In pivot table I have measures for which dimension have to be different for different measures, hence I created a static dimension now I need these measures to be linked to value in dimension, hence I need to know how to reference dimension in measure calculation
Reference the Dimension by fieldname, eg
if(Region='EMEA', ...
-Rob
There are 250 value in that field hence it has to be dynamic