sort the total in last

building reports webintelligence
1

Hi,

I created the total as one of the column value and when i displayed the column by default it display in the asc order, but i need total to be displayed as last value. i can do that my custom chart, but if query is referesh or other new values are added to that column, the dat is in asc oder.

ex:

column value
one
two
three
four
total.

if i add one value to that
then

five
four
one
three
total
two.

but i want to diplay total in the last, whatever the other values may be

like

five
four
one
three
two
total.

if any body know how to place the total always last?

Thanks
in Advance.

geethanjali (BOB member since 2010-06-07)

2

How you created Total ?? why cant you apply break on column ??

patriot3029 :india: (BOB member since 2006-12-08)

3

I created the total by using the union in the sql query . since i need to add the total also displayed in the chart.

so i created the sql with the union and combined the total as a column value.

geethanjali (BOB member since 2010-06-07)