Show all values in dimension irrespective of another dimension
Hi,
I am badly stuck with a problem. I have a pivot chart wherein i have 5 dimensions. The last dimension is aligned horizontally. I want my first dimension to display all the values independent of the selections made in one field. Also i want my first dimension to display all the values independent of the horizontal dimension.
I tried with "Show all values" and unchecking "Suppress 0 values" but no luck.