Is it possible to return a dimension value using the Set Analysis P() notation? In essence, I am looking to find the Account that had the highest sales by Product Category.
My Chart Dimension is Product Category. I have an expression that returns the highest sales contributed by an account. But I need another expression that now tells me who that account is without having to add the Account as a dimension in the chart.
Is it possible?
FieldIndex works but for simple expressions. It falls apart when we have a complex expression with multiple parts to it.
FirstSortedValue does work but with limitations. Have to get workarounds to ignore certain things.. So in summary, both are good solutions. Thanks all.
I agree with you FieldValue & FieldIndex works but if you wanted to play with Sets then you need FirstSortedValue(). Which is very powerful and you can be very clever with it.