How to remove the column of one dimension in pivot table

[#1]

Hi all,

I have a pivot table and it has two dimensions date and used. How can i move the column of used? I dont want it show in my report....

Thanks

Jelly

[amit_saini]

Jelly,

This is not possible in pivot table but you can hide this in straight table.

Thanks,

AS

[Anonymous]

Just make it as narrow as possible, and replace the label with blank text.

[mohammadkhatimi]

Hi...

In label "Used" dimension...add blank spaces..

Regards,

Mohammad

[#5]

in Dimension Label.. make it blank and then drag the column to as narrow as possible.

[#6]

Hi Jelly,

As per my understanding I guess that you want to remove the column "Used" from the report. In case you are looking to remove it completely from your report (and do not want to group the calculations with its field values) then simply remove it from the dimensions list.

Else in case if you want to hide it temporarily or permanently you can do that as below

1. Just open the Chart Properties and go to the Dimensions tab.

2. Click on the Used dimension field and check the enable conditional dialogue box

3. You can give a condition as 1=0 and the “Used” dimension will remain hidden.

I hope this will help

Thanks,

Amey

[#7]

Hi

I have tried this way, but the blank text could not be narrow as small as the cell in the report. So some how the line under the cell has been cover and could not show normally....

Could any other way to fix it?

Thanks

Jelly

[#8]

Hi

I have tried this way, but the blank text could not be narrow as small as the cell in the report. So some how the line under the cell has been cover and could not show normally....

Could any other way to fix it?

Thanks

Jelly

[#9]

Hi

I have tried this way, but the blank text could not be narrow as small as the cell in the report. So some how the line under the cell has been cover and could not show normally....

Could any other way to fix it?

Thanks

Jelly

[mohammadkhatimi]

Please post sample data..