Skip to Content
Former Member
Nov 29, 2011 at 09:51 AM

Problem with ranking and sorting it



I'm like a newbie in Web Intelligence, working with it since one or two weeks now.

I have the task to create a ranking by Top 10-Stores for my sales. So far no problem, but it should be sorted by one year. Actually it's sorting for the sum of sales and not for one exact year. If I try to manage the sorting, I'll get a error.

It should look like this example:

Store 2010 2011 Difference

1 10,000 9,800 -xy

5 9,000 11,000 + xy

6 5,000 6,000 +xy

In this example, it should sort the ranking for the year 2010 and not for the sum of sales.

Is the problem clear? Did Somebody have a solution?

I'm working with Web Intelligence for SAP BO 4.0 and a .unx Universe with a SQL Database as the data source

Edited by: Fatih-Mehmet Inel on Nov 29, 2011 10:53 AM