Formatting and alignment of Value based on the expression

[#1]

Hi,

I am having a column with the name Value,in the value column i am having different format of data like string date and numbers.

Value Field(Column):

10-03-2016

12-09-2016

ABC

DEF

100

200

ABC-100

DEF-200

I want to show all the values in the pivot using expression.

When i am using SUM(Value) then only getting numbers and when using purgechar then not getting date.Pls help me for expression which will handle all the values accordingly.

2)Formatting Issue:

The above values in want to show like this

if numbers then right side of the report alignment

if date and string then left side of the report alignment

How can we handle the the values alignement based on the data for a particular column where data is not fixed like we are getting numbers ,dates,string ?

Please help...

[sunny_talwar]

1) May be you need to use Only(FieldName)

2) Set the alignment for text and numbers on the presentation tab of your chart properties

[Chanty4u]

presntation tab--->alignment