COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dollipi on 27 Aug 2014 06:31:15 AM

Title: sort measures in crosstab
Post by: dollipi on 27 Aug 2014 06:31:15 AM
Hi,

i have a crosstab and I can sort the columns and rows, but not the measures.
In my case I have quantities that I want to sort in ascending order.

Can anyone help?

Thx
D.
Title: Re: sort measures in crosstab
Post by: MFGF on 27 Aug 2014 06:41:22 AM
Quote from: dollipi on 27 Aug 2014 06:31:15 AM
Hi,

i have a crosstab and I can sort the columns and rows, but not the measures.
In my case I have quantities that I want to sort in ascending order.

Can anyone help?

Thx
D.

What do you want to sort by quantity value - the rows or the columns? If you're sorting the rows, what column do you want to take the quantity values from to sort by - the summary? Ditto for sorting the columns?

MF.