Rank and Horizontal Stacked chart

building reports desktopintelligence
1

Hi Everyone,

I have a requirement where I am showing top 10 cities based on the number of trips.This works fine when I used Rank.Now when I convert this table to a horizontal stacked chart,it shows the top 10 cities but in reverse order.

Is that how the graph shows in BO.I am using BO 6.5.1

Appreciate your help
Thanks

nisha_18 (BOB member since 2004-08-10)

2

Being that I have just had to do the same thing - and found no luck on the web - I thought I would explain how I got it working.

Lets say I have Stores - each store generates revenue.

I want to have a horizantal column chart - stores on the Y axis - revenue on the x-axis.

If I rank the revenue - take the top 10 - then chart I get the store with largest revenue at the bottom.

So if BO can work backwards - so can we.

Create a variable that is the negative of the revenue - rank on that taking the bottom 10. Create the horizantal chart - buy display the positive revenue.

That way your biggest revenue store will be at the top.

Hope that helps anyone who has hit a similar problem.

:hb: :hb: :hb: :hb: :hb: :hb: :hb: :hb: :hb: :hb:

ngummow (BOB member since 2007-11-22)

3

Thats great…I will try this solution.Thanks for sharing

nisha_18 (BOB member since 2004-08-10)