Alignment on Null Values in Pivot Table

[#1]

Hi

I have a pivot table in which label is left aligned and my data is right aligned but null values(-) is coming as left aligned.

What could be the solution?

Thanks

Saurabh

[#2]

what do u want eactly here

[#3]

Hi,

In Dimension you have null values so mat be it came like that.

Plz check the dimension nullcount(DimensionField)

[Anonymous · Accepted solution]

On the Presentation tab of your Pivot Table you will see 'Null Symbol' which defaults to '-' :

• Delete the '-'
• Click <apply>
• Put the '-' back in
• Click <apply>
• Make sure 'Data (Text)' is set right aligned