Link to home
Start Free TrialLog in
Avatar of Sailee Govekar
Sailee GovekarFlag for India

asked on

Record sorting in Cross tab

Hi,

I have a cross tab in a group header.

I want to sort cross tab according to the third row.

How to achieve this?

For example, the attached image.
User generated imageI want to sort the cross tab as per Part 3
SOLUTION
Avatar of Raghavendra Hullur
Raghavendra Hullur
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

I agree.  

The data is grouped by column one so then by column 2.  You can't cause a group to be split up.

The only way to sort by Column 3 is to make it the primary group.

Perhaps if we understood what you are trying to accomplish we could think of a way to do it

mlmcc
Avatar of Sailee Govekar

ASKER

@mlcc and @Raghavendra

Thank you for your valuable feedback. I cannot display column 3 as my first field because it is in the column 1 hierarchy and so on.

Just sorting by column name is not possible?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi @Raghavendra,

Thank you for your feed back.
Good explanation