Urgent help please .. How to remove extra space?

[#1]

Hi,

i have pivot table. all is fine but at the top it is showing blank values count. How can i remove it. I tried supress null values but nothing works.

Thanks.

[#2]

in dimension

check supress null value

[er_mohit]

Right click on chart Fit coloumn to Data

[#4]

Thanks I did it earlier but it's not working. Any help please?

[#5]

Thanks. It's not working. Any help please?

[MK_QSL · Accepted solution]

From-To is having null values...

You can add below in Script

IF NOT ISNULL([From-To], [From-To]) as [From-To]

or at the end of the script....

Where NOT ISNULL([From-To]);

[#7]

Can you share your app?

[manideep78]

After Load statement put where clause

WHERE [From-to] <>' '

Hope this helps

Regards

Manideep

[amit_saini]

Hi Ameila ,

Have you tried "Suppress When the Value is Null" Option under Dimensions Tab ????

I know you have mentioned this option already in your post but same kind of option is present under Presentation Tab also I don't know which one you have already tried.

Thanks,
AS

[#10]

Thanks.

Actually the columns from-To is alias column like below

What& ' To ' &Queue       as [From-To],

So, how can I change this? Please help