Good Morning Experts!!!
I´m new in BO, and i am trying to do a ranking in a webi report.
In my report for i have the following information:
Country
State
Its important to say that a country can have one or more states, then that i want to do is to order in first place the country with more sales and inside the country also order the state with more sales.
Example:
Country State Sales
Country 1 State3 1000
Country 1 State1 100
Country 1 State2 50
Total Country1 1150
Country 3 State 20 500
Country 3 State 10 250
Total Country3 750
Country 2 State 5 100
Country 2 State 6 50
Total Country2 150
Any idea??
Pleas help me.
I will wait for your answer.
Im using BO XI 3.1 SP3.
