space issues in pivot table

[#1]

Hi

How to remove the extra spaces / extra column in pivot table

Can you guide me

do guide me soultion

[alexandros17]

You have a dimension whose values are "Budget" and "Actuals", for that diomension check the box "Suppress when value is null"

Let me know

[Anonymous]

Hi,

Suppress dimension which contain Budget and Actual value.

[amit_saini]

Try Satyadev suggestion , it should work.

Thanks,
AS

[#5]

Select the dimension and check the supress when value is null.....

[#6]

This space comes if more than one dimension is there.Try to use one dimension and rest are as measures.

[#7]

Hi

Thanks for your quick resposne.

It doesnow work and not removing extra spaces

[male_carrasco]

hi!

Check "Always axpanded"

Best Regards,

Ale.-

[#9]

HI

sry "Always expanded" option is also not yeilding results.

can anyone suggest me any further ideas.