WebI custom sorting

building reports webintelligence
1

Hi All,

I have a table like below in my WebI XIR2 report:

User Group Nov Dec Jan Feb Total

ab xyz 12 13 14 73 Sum for all the months
cd ade 25 76 87 23 Sum for all the months
…
…

My Requirement is to sort all the values based upon the data for current month(Feb in this case).
Currently when I try to sort on Feb,it gets sorted on the total field(as total is the sum of all the fields).
Any help will be highly appreciated.

Thanks a lot.

abhi4u :canada: (BOB member since 2009-02-11)

2

Is it a crosstab block
How are you getting the total column in the end and on what column in the crosstab are you applying the sort
Give the columns mapped on to the block

.

haider :es: (BOB member since 2005-07-18)

3

Yes haider,it’s a crosstab block.
The total column is the horizontal sum for all the months.
We need to sort the data on the current month column only and not on the total values.

Thanks,
Abhijit

abhi4u :canada: (BOB member since 2009-02-11)

4

any ideas on this issue?

abhi4u :canada: (BOB member since 2009-02-11)

5

Do you have any other sorts applied to your cross tab? Usually, that is what I have seen to be the cause.

Hope this helps,

Mitra

Mitra Moini (BOB member since 2002-09-01)

6

When you apply sort on body of crosstab it will not consider only for the “Feb”. In cross tab it will consider the first column and apply sort on that. in your case if you apply sort on measure it will be applicable to month “Nov”.

Prashu :india: (BOB member since 2005-08-17)

7

Try to add a row above the Month column and pull the same object on that row and apply custom sort on that field

dont forget to hide that row…

hopw this will help u

yalisis (BOB member since 2009-07-27)

8

Try to add a row above the Month column and pull the same object on that row and apply custom sort on that field

dont forget to hide that row…

hopw this will help u

yalisis (BOB member since 2009-07-27)