We have 4 dimensions being used in our pivot chart.
3 dimensions are in the x-axis and 2 dimensions are on the top ( y-axis). The measue forms the chart area.
We have a requirement, where we need to show only all the Values of the 3rd 4th and 5th dimension alone. The first and 2nd dimension can get filtered based on ZERO rows of the measure. But for other dimensions all the values must be visible even if the meausre value has ZERO.
When i select "show all values" and deselect "Suppress Zero values" it shows all the values of event the 1st dimension. How can i bring in all the values of other diemnsions except 1st.
In the attachement, the Usage column has to have "ALL VALUES' and also the Reports and Serious/ non serious needs to display ALL vaules.
But the country and species need not display all the values. Aso the number of countries is very large to display them.
