how to remove extra row from pivot table

[Anonymous]

[sorrakis01]

Hi,

On dimension check Supress when value is null. And if you like in presentation you can supress zero values too.

Regards

[kuczynska]

Isn't that more likely Suppress When Value is NULL in Dimension tab?

If you don't want to display Null values, simply tick this checkbox.

[maximiliano_vel]

Check Suppress When Value is Null in tab Dimensions

[krishna20]

Hi

Goto Properties->Dimensions tab-> Select Region_Hierarchies_Name-> Suppress when value is null.

Hope it helps..

[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

[krishna20]

Hi Nilesh,

The Last row is not dimension of your table.It's showing the value of null which belongs to the field Region_Hierarchies_Name. I think the last row no need to show at this part. In your table there is no null values. So no problem.Instead of showing that row, better to show totals at last row.Hope it helps.