Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
presntation tab--->alignment