sorting not working in crosstab -cognos 8.1

[Manu0521]

Hi,

For internal users we are using cognos 8.1.

I am trying to do a simple descending sort on my columns
Salesrep on rows, product on column and qty as measure.

I am able to do sorting in cognos 10.but cognos 8.1 doesnt sort. It behaves odd and I could nt find the reason . It works fine for list report.

Any help is appreciated.

Thanks,

[MFGF]

Hi,

For internal users we are using cognos 8.1.

I am trying to do a simple descending sort on my columns
Salesrep on rows, product on column and qty as measure.

I am able to do sorting in cognos 10.but cognos 8.1 doesnt sort. It behaves odd and I could nt find the reason . It works fine for list report.

Any help is appreciated.

Thanks,

Are you doing this from a dimensional or relational package? How are you implementing the sort - using the sort button? What does "It behaves odd" mean? Is it sorting the products based on the summary product column values (ie the total for each product for all reps)? How do you want the product sorted - by name?

MF.

[Manu0521]

I am working on dimensional product.

Just have sales man in rows , quantity in measure and product in columns. say sales rep sold 10 quantity for product A and sales rep b sold 20 quantity for product a.
Qty
SalesRp  Product A
A              67
B               55
C              43

This is a simple sorting, I am click on the column and say sort by desc on value and it doesnt sort.

The same works in cognos 10.

[MFGF]

Hi,

But you're not sorting the product members here - you're sorting the sales rep members based on the measure value in the Product A column? Shouldn't you be sorting Sales Reps?

An alternative would be to replace the sales reps item in the rows with a query calculation:

order([Your Sales Rep level],tuple([Product A member],[Quantity measure]),BDESC)

MF.

[Manu0521]

Hi MFGF,

That works , I am doing the same thing but i have a issue , this is my req.


Sales Rep in rows
Qty as Measures and
I have two products A and B and I am Doing having a Total column and this is nested with respect to ytd in columns.

Qty   Product A      Product B      Total   
SalesRep   YTD   PYTD   YTD   PYTD     YTD1   PYTD1
A            100   200   150   200          250   400
B            200   100   150   200           350   300

Here I should sort my saes rep by qty for the total column PYTD

My expression was

order([Salesman],tuple([PYTD1],[QTY]),BDESC)
Here total is query calculation with product a and product b

It is not sorting when i gie above expression

Thanks,

[Manu0521]

I added the nested level in tuple function and used in order function and it worked. Thanks a lot MFGF you have been very helpful.

[MFGF]

I added the nested level in tuple function and used in order function and it worked. Thanks a lot MFGF you have been very helpful.

You figured it out before I could reply! :) Glad you managed to get it working!

MF.

[Manu0521]

Hi MFGF,

There is a issue when I drill down on my sales reps. It doesnt sort my next level which is customers.

Is there any fix for this..

Thanks,