Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps, Presentation tab ->Dimension and Expressions -> Data Alignment ?
Perhaps, Presentation tab ->Dimension and Expressions -> Data Alignment ?
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.
Thanks. That's right.
Thanks. That's helpful.