Can we apply sorting on Column values in Cross tab??

[Former Member]

Can we apply sorting on Column values in Cross tab??

Following is the scenario with me.

I have 2 fields and one formula.

Fields are HostName and Username.

Formula is status which categorizes the Authorized and Unauthorized events.

And in the Summary Field, I am calculating the total number of events.

In cross tab, Fields are marking the Rows of the cross tab and Formula is making the Columns(Authorized and Unauthorized ) of the cross tab.

Since in cross tab data is grouped from left to right and sorted by default. I want to remove this default sorting and want to put sorting on the formula for Unauthorized events.

Is there any way to fulfill this requirement?

[Former Member]

Hi,

You can assign a number to each Unauthorised field e.g

Rank Unauthorised

1 A

2 BC

3 DF

5 TD

6 GF

Then add "Rank" to the crostab Columns before the Unauthorised field. Then you can control the sorting order on your crosstab.

Hope this helps

Regards

Dotun

[Former Member]

Hello Jehanzeb,

Group options under column options sorts the column headers not the column values. I want the column values to get sorted.

Hello Dotun,

The cross tab I am using is Dynamic Cross tab. At run time at calculating the data of Authorized and Unauthorized Column. How Can I assign the rank to values at run time?

Thank you,

Regards,

Amrita

[Former Member]

Hi Amrita,

The crosstab column values can be sorted by using "Group Sort Expert".

1. Select the CrossTab and click on "Group Sort Expert"

2. Change "For this group sort" drop down to "ALL"

3. "based on" drop down will appear and can select the column group value to sort either Ascending or Descending.

Hope this helps.

Regards

Dotun

[Former Member]

Morning Amrita,

you can certainly do that by right clicking on the column and click Group options under column options and then from the ascending drop down menu choose "Specified" and then specify how you want it to be sorted.

Many thanks

Regards

Jehanzeb