Sorting issue in COGNOS Workspace Advanced(Crosstab report)

[samiar784@gmail.com]

Hello!!

I am trying to sort the year column on a crosstab, but getting the below warning.

"There are no sets to sort on the opposite edge".

Thanks in advance.

Sameena

[MFGF]

Hello!!

I am trying to sort the year column on a crosstab, but getting the below warning.

"There are no sets to sort on the opposite edge".

Thanks in advance.

Sameena

Can you give us more information? What *exactly* are you doing to implement the sort? What do you have in rows, columns and cells?

MF.

[samiar784@gmail.com]

Thanks for replying. This issue is happening to my user, I am getting the sorting right. My crosstab has countries as the rows and years as the columns. I am trying to sort on one of the year column. But on doing so I get the attached warning. :(

Regards,
Sameena

[MFGF]

Thanks for replying. This issue is happening to my user, I am getting the sorting right. My crosstab has countries as the rows and years as the columns. I am trying to sort on one of the year column. But on doing so I get the attached warning. :(

Regards,
Sameena

Can you describe exactly what you are doing? "I am trying to sort on one of the year column" is very vague. How are you doing this? What steps are you taking?

What sort of package are you using - relational or dimensional? What are "Countries" and "Years"? Are they query items? Member sets? Calculations? Attributes? Something else?

MF.