How do I return a member name where a value is at a MIN / MAX
Summary:
I need to find the MIN / MAX value of a given account across the cross dims shown below and I can do that using the @MINS / @MAXS functions.
Next, I want to find and store in Account members, the member names of CustomDim_1, CustomDim_2 and CustomDim_3 where the value of Account_1 is at a MIN / MAX.
This is where I need some help with the code - How do I get the members?
Content (required):
Here is the Fix to find the MIN / MAX value.
Fix(“Jan”,”FY21","USD","Actual","Working",”No Plan Element”,
"Entity_1",
"No CustomDim_1",
"No CustomDim_2",
0