Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to use only() function in dimension side.
For EX: If I will select B option and field A is having only 1 value related to B then it should display A/B like that.
try in dim:
=aggr(only(Dim1),Dim1,Dim2)