Display null value right side

[Lucky1]

Hi i have a pivot table

Status.             Count (Id)

Completed.                    2

Pending.            -

Pending is showing - because I don't have data for pending but null is showing left side of the column but I want to show it below 2 like below

Status.             Count (Id)

Completed.                    2

Pending.                          -

[Chanty4u]

try

num(ID) as  ID

[Lucky1]

Hi chnty

Thanks for your reply it'sN ot working 

[Chanty4u]

Try this 

If(IsNull([Count (Id)]), '-', [Count (Id)]) as id

[marcus_sommer · Accepted solution]

The NULL replacement of '-' is a string and therefore in the standard-settings left-aligned. If you want to change it to right-aligned you need to change the layout-settings or you need to replace the NULL with a real value, maybe:

dual('-', 0)

[Lucky1 · Accepted solution]

Thank you for your reply.in measure i kept text alignment to right