Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table that its analysis set varies depending on the dimension. It works correctly with the "Dimensionality () function. "The problem is when the user moves the dimensions. Can someone help me to retrieve the field name of the first dimension? Thank you so much
Metric
example
if(Dimensionality ( )=1, sum(sales),sum(sale)-sum(cost))