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.