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.

[maxgro]

are the values nulls?

if not trim them or change to nulls

[MK_QSL]

If you can please share your file, it will be easy for everyone to answer rather than just guessing!

[#4]

Thanks. I tried both but not working.

[#5]

hi

i think you have multiple dimension, firstly expand all dimension, then check that in any dimension must be show any value. and then remove this dimension and use this dimension  in expression. After that select each dimension in dimension tab and check supress null value.

[#6]

Thanks.  In another application it is ok.