Thanks for your reply.Row(total) worked as I have more than one dimensions.
I have one more question..
Straight Table Chart contains
date1 date2 days row(total) 11/5/2011 11/1/2011 4 1 11/5/2011 11/3/2011 2 2 11/10/2011 11/5/2011 5 3 11/22/2011 11/21/2011 1 4
days and row(total) are expressions.
after adding row(total),now sorting on days(descending) order not working.The days should look like below
days row(total) 5 1 4 2 2 3 1 4
is there a way it can be fixed.when I remove this row(total) sorting works fine.
The reason why the sort doesn't seem to work is because rowno() is a chart inter record function, and for these functions the Help states:
Note: Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when Chart Inter Record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.
Suppression of zero values is automatically disabled when these functions are used.
Though sorting on numerical should work if I read above lines correctly, in fact it seems it doesn't work correctly.
You are probably using something like =date1-date2 as expression to calculate days, right?
Try moving this expresssion to dimensions as third, calculated dimension. Then sorting on days descending seems to work, having only one expression, rowno(total).