How to remove null dimension from pivot table

[Anonymous]

All the header are dimensions ,I wanted to show all values including zero value. But when show all is checked it adding one extra dimension at the bottom of table and I want to remove it.

[settu_periasamy]

Hi,

Did you checked, Suppress When value is null in dimension Tab?

[Anonymous]

No, Because if I check suppress when value is null in dimension tab then remaining  all zero values (above the bottom row)will disappear  and I want to display that.

[settu_periasamy]

for clarification, do you have the value for the dimension(Region_Hierarchy_SName, Model, Model year)  which is showing value zero?

And, checking purpose, convert your pivot table to straight table, again check, still the null value displayed or not?

is it possible to post the sample app?

[Anonymous]

yes I have values for all the dimensions and  it will display according to my date selection .in above picture I have only selected April month so its showing me value for April and rest all are zero.

one more thing that month names which coming on header is also one dimension with name NewDim.

below I am sharing my dimension tab screen shot.