How to change the layout of the data in cell in pivot table?

[#1]

Hi,

I have data as below in pivot table.

Header 1
34
89
0
90
34
56
0
0
0
24
42

I have changed blank values to 0 under Presentation Null Symbol and Missing Symbol.

I need the 0 values should appear at the right side of the cell. so, I need the output as below

34
89
0
90
34
56
0
0
0
24
42

How to change this? can anyone suggest me please.

Thanks.

[terezagr · Accepted solution]

Perhaps, Presentation tab ->Dimension and Expressions -> Data Alignment ?

[mjayachandran]

As far as I know in the same pivot in Presentation view under Alignment -> Data(text) set the dot under right.

But problem is if there is any alpha or alpha nuneric values it will also come right aligned.

[#4]

Thanks. That's right.

[#5]

Thanks. That's helpful.