Dynamic sorting problem in cross tab report

[srinivaschukka]

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...

[Suraj]

That extra column "new customer" is a waste.
One idea for you is since both columns are same, sort using the one that came from cube ie. -1000 not (1000).
But keep in mind that in crosstab, your row levels won't change on sort.
You have Location, Time and Employee as rows. Sorting on column will not move the rows up and down.
You have to find a way to sort the rows instead of columns.

[rockytopmark]

With Powercubes, use MDX function Order() for sorting or TopCount() and BottomCount() for sorting and rendering a specific number of rows.  Each as the ability to sort in Ascending or Descending order