Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Jelly,
This is not possible in pivot table but you can hide this in straight table.
Thanks,
AS
Just make it as narrow as possible, and replace the label with blank text.
Hi...
In label "Used" dimension...add blank spaces..
Regards,
Mohammad
in Dimension Label.. make it blank and then drag the column to as narrow as possible.
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
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
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
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
Please post sample data..