Hi,
I have one cross tab report.
----------------------------------------------------------------------
( measure= revenue) |product | customer | new customer |
---------------------------------------------------------------------
Location | 1000 | -1000 |(1000) |
----------------------------------------------------------------------
Time | 2000 | -2000 |(2000) |
-----------------------------------------------------------------------
Employee | 3000 | -3000 |(3000)
-----------------------------------------------------------------------
Assume that the above is the cross tab..
And customer and new customer values are the same..I mean instead of the negatime values(-), the user want to display the values with in brakets'()'.. that means [ (1000) =-1000 ].
Now the requirment is that I would liketo sort the customer and new customer values dynamically....
I am using the script to dynamically sort the product, and customer and new customer...
ther is no problem in sorting the product column...and when come to the customer its sorting perfectly a the values are in -ve.
the problem with the new customer is that ...values are sorting normally
but my requirment is the values should be in -ve instead of ()..
assuem that (1000)= -1000
(2000) = -2000
(3000)= - 3000
when I sort it dynamically...( ascending order)
I want to display the values as ...
( ascending order)
-3000
-2000
-1000
but the display is in reverse manner..( as it is not considering the -ve values)
1000
2000
3000
-------------------------
Note: the sourse of the package is from Transformer cube)
considering the above description.....
please let me know how to solve the problem...
is customer a string...? if it is sorting is working properly. if it is a string you will have substring customer and convert to a numeric value and multiply by -1 then sort