Forum

This content is now out of date.

Visit Our Community

Crosstab Report – Sort Issue


I am using three dimensions & one metric in my cross tab report(Chart & Table). I also used column & row totals. Now i would like to sort the sum of my metric in ascending or descending order, however, am unable to achieve this using cross tab reports(Chart & Table). Please suggest a solution for this.
Hi,

Unfortunately, due to how cross-tab reports are generated, this is not possible.
The data is returned from the DB , and then the report is generated into a cross-tab.
If you were to sort a metric the cross-tab would need to be regenerated again , as it will affect column/row order.

This is something that has been raised as an enhancement request (TASK ID =104128) though at this point in time, no confirmation can be given that it will be possible in a future release.

Apologies for the inconvenience.

Regards,
David


Hi David,

IS this issue fixed in Yellowfin 7?
Hi,

Nope, unfortunately you are still unable to sort data in a cross-tab report.

Regards,
David
Any update, this seems a big miss in the ability to make a report readable?
Hi,

there is no further update with regards sorting data in a cross-tab report.

regards,
Dave
12 months since it was added to the dev backlog, and 8 months since last statement.

Is this still a dev item that is being considered?
Has there been any update on this as I'm unable to sort on a
Forum image
?
Hello Guest,

Unfortunately there is no movement on this enhancement request. I did add a note to the task indicating your interest. The enhancement request priority is also currently at HIGH.

Thank you,

Kyle

Just reiterating again the interest in easily sorting when using cross-tab reports.
Hi all

I have found that Row and Column Total sorting is possible in a Cross-Tab report, however, only if you have a single Dimension value in the Row or Column that you want to sort.

That is, if you want to sort by Row (say in descending order), you can only have a single DIM in the row.

When you have only a single DIM, the following options appear under ROWS property of the table:


Forum image


(Not at all intuitive I grant you ... )
Hi Adam,

Thanks for the contribution and screenshot. :-)

You're right it's not particularly intuitive and we should certainly update our documentation.
I'll pass along your feedback.

Kind Regards,
Cadell.