Sorting in Chart

[ashishpalkar]

Hi There

I have below requirement ,

I have created line chart, the dimension data is coming as follows ,

MAR 2015

DEC 2014

AUG 2015

DEC 2015

JUN 2014

AUG 2014

JAN 2015

JAN2014 ... and so on.

I also have expression created as Sum(total)

In graph display I want to show above data in ascending order.

Thanks,

[Anonymous]

if your Dimension has a date Format you only Need to sort Dimension ascending (tab sort)

if your Dimension has a string Format you Need to transform it to a dateformat using

date#(stringdimension,'MMM YYYY') in tab sort "expression" and ascending

[ashishpalkar]

Thanks its working using date#(stringdimension,'MMM YYYY')