Hi, CR 2008 and Universe data source
I have a similar issue to this thread i found but it does not solve my issue.
I have a report that groups by Region. within the Region GHa I have a XTab that shows the Countries as Rows, the Months as columns and summaries three field
1.) net_Sales.sales
2.) @maxdate_NetSales
// if maximum([month.sales])=[month.sales] then net_sales.sales else 0
3.) @mindate_NetSales
// if minimum([month.sales])=[month.sales] then net_sales.sales else 0
values 2 and 3 are hidden in that i made the font white so the end user doesn't see them and only sees the net sales in the cross tab.
I have a group sort top N on the cross tab so that the country are sorted to show the top 10 per region based on the @maxdate_netsales.
I want to produce two charts that display in GHb that will display the top 10 countrys. One will produce a pie chart of the @MaxDate_NetSales value, the other will produce a pie chart on the @MinDate_NetSales values. So far this works correctly and displays the correct 10 countrys per region (that have the top sales for the last period) however the countries are sorted Ascending based on name.
I would like both chart legends, and chart pies for that matter, to be sorted based the same order as the XTAB sorts them - or essentially descending based on value for @maxdate_netsales.
I attempted to do advanced feature on the charts but because they are based on the cross tab itself and not the full set of data, the Top N option was greyed out. even sort original order too was grey.
I can do 2 separate charts based on group and country and sort them advanced based on top N and this will produce the @MaxValue chart correctly but would produce the @MinValue chart based on the top 10 mindate_Netsales value and those top 10 may or may not be the same countries or order of countries as the @MaxDate_NetSale top 10 countries.
I hope i've explained this well. If anyone knows of a work around or solution please let me know.
I have a similar issue to this thread i found but it does not solve my issue.
I have a report that groups by Region. within the Region GHa I have a XTab that shows the Countries as Rows, the Months as columns and summaries three field
1.) net_Sales.sales
2.) @maxdate_NetSales
// if maximum([month.sales])=[month.sales] then net_sales.sales else 0
3.) @mindate_NetSales
// if minimum([month.sales])=[month.sales] then net_sales.sales else 0
values 2 and 3 are hidden in that i made the font white so the end user doesn't see them and only sees the net sales in the cross tab.
I have a group sort top N on the cross tab so that the country are sorted to show the top 10 per region based on the @maxdate_netsales.
I want to produce two charts that display in GHb that will display the top 10 countrys. One will produce a pie chart of the @MaxDate_NetSales value, the other will produce a pie chart on the @MinDate_NetSales values. So far this works correctly and displays the correct 10 countrys per region (that have the top sales for the last period) however the countries are sorted Ascending based on name.
I would like both chart legends, and chart pies for that matter, to be sorted based the same order as the XTAB sorts them - or essentially descending based on value for @maxdate_netsales.
I attempted to do advanced feature on the charts but because they are based on the cross tab itself and not the full set of data, the Top N option was greyed out. even sort original order too was grey.
I can do 2 separate charts based on group and country and sort them advanced based on top N and this will produce the @MaxValue chart correctly but would produce the @MinValue chart based on the top 10 mindate_Netsales value and those top 10 may or may not be the same countries or order of countries as the @MaxDate_NetSale top 10 countries.
I hope i've explained this well. If anyone knows of a work around or solution please let me know.