| TopN analysis not displaying column in rank order for main report [message #547158] |
Tue, 13 March 2012 02:06  |
 |
AnjaliG
Messages: 1
Registered: March 2012
Location: chennai
|
Junior Member |
|
|
HI,
For a topN analysis report,
Am using an intermediate report to fetch the top10 countries and connect it to the main report by prompting the country column with the intermediate report.
However in the main report ,the countries fetched, are not dosplayed in rank order.
Please help with this.
|
|
|
|
| Re: TopN analysis not displaying column in rank order for main report [message #562994 is a reply to message #547158] |
Tue, 07 August 2012 12:27  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Correct, how could it do that? So you have to somehow include an sort order column in your main request, to order by. Sometimes a sum (by dim) can do the trick. I.e. Sum(amount by country). Then even if you gave lots of more detailed columns in your request (like customer name or product group etc), you can still use that sum by as sort order. Hide the sum by column though, sort order will still work.
By the way, if you get this to work, you can most likely get rid of the supporting request, all you need is in the main request then.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
