Blank space

[smilingjohn]

Hi All ,

Please find the attachment of the QVW application .

I have a pivot table ,  if you look i have made the Date(Month) to appear horizontal , i am facing a Ui issue here ,

If you observe at the column Branch there is a slight space , and i cant fill it .

Can somone tell me how do i elimnate this blank space ?

Thanks .

[rahulpawarb]

Hello John,

Trust that you are doing good!

The space you are referencing is the column header for Date(Month) field. I strongly believe that you can not remove it from cross tab.

Hope this will be helpful.

Regards!

Rahul

[vijetas42]

Hi,

you can not delete that blank space from pivot table for just to do adjustment you can put same color text box on that smaller space so that it will look like part of column branch.

[smilingjohn]

Hi Viheta ,

Thanks for the reply ,

I used a text object with same column , But the thng is that when there is no data , only two column will be shown , and this text object will appear like a patch , which needs to be invisible when there is no data . for total column

[neha_shirsath]

Hi John,

Please find the attached file, hope it is what exactly you want.

For this go to your dashboard setting>Design tab> enable Always show Design Menu Items.

Then right click on your chart properties and click on Custom format cell then arrange color and background color accordingly.

Let me know if you understand this.

Thanks,

Neha

[stabben23]

Hi John,

you could use a macro as a workaround. You need to trigger the macro in some way, maybe by onopen.

Sub HideDim 
set chart = ActiveDocument.GetSheetObject("CH01") 
set p = chart.GetProperties 
' set the width of the 4th dimension to 0 
chart.SetPixWidth 3,0  '3 will be your 4th dim, starts with 0
End sub

[smilingjohn]

Hi Neha ,

I followed ur steps but its not working in my real time app .

[neha_shirsath]

You have to do some trial and error.

What I have attached in that file,I think same way you have to do.

check properties of the same,It should work.

Thanks,

Neha