Sorting in Crosstab Webi report

[Former Member]

Hi Experts,

Need help urgently for the below requirement..

We have requirement to display the Months(Jan-13 to Aug-13), Quarters(Q3, Q2, Q1) and Last last year(fiscal  Year data) in Crosstab Webi report.

When we are doing custom sort for the above requirement sorting is not coming, the above months, quarters and LLY are displaying randomly.

Can any one help me how to do custom sorting in Webi Cross tab report.

please find the below snapshot for reference..

[former_member183330 · Accepted solution]

Hi,

Create A Variable for months and another variable for quarters.

Add 2 Rows above of your dimension in cross tab and do the sort based month and quarter like below picture

Add the Rows like below picture

After adding this rows Right click on row and hide the dimensions one by one.

Thanks,

G Sampath Kumar

[Former Member · Accepted solution]

Hi Sampath,

Thanks for the correct inputs...