Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Gurus,
I have made a pivot table with one expression and 5 dimensions. out of 5 dimensions i brought 2 dimensions as columns. Then my Expression label is missing.
If I do the same with 2 expressions(clacualtions) I can see labels.
Pls let me know how can I see the label if I have only one expression. Is it a limitation?
Please see the screenshots.
BR,
Neeru
can you post a sample app? Not happening for me.
Hi,
PFA Sample app and data.
BR,
Neeru
Does any one has the solution for this issue? pls help
The only thing I came up with is creating a dummy 2nd expression and setting the width to 0 so it does not show. You will need a macro to set the width to zero.
But why is it so important? Since it is one expression, you can put the description in the charts caption.
Hi Jonnis,
My expressions are dynamic based on user selection(in List Box) I will show only one expression at a time.
I tried with the second dummy expression early but wasn't able to hide it.
Kindly share the macro to set width to 0 of my dummy expression.
BR,
Neeru
Hi Neeru, not tested and I don't know how it will affect performance but you can try to add a calculated dimension after day, ie:
=$(=Chr(39) & SelectedExpressionField & Chr(39))