applying ranking only on latest month

building reports webintelligence
1

Dear all,
i have the problem like i have unitwise data for 3 months and in my webi i want bottom ten units of last 3months where units wikll be ranked based on latest month.If anyone knows kindly help me with the solution.
EX:- units mar april may
oranges 10% 10% 20%
mango 5% 12% 23%
grapes 14% 16% 25%----------

like this how we can get this?

varsha singh (BOB member since 2012-06-21)

2

Hi,

If my understanding of your requirement is correct,below is the solution.

—>create a variable to get the Latest month.

—>Create one more variable as below

Month Where ([Month]=[Latest Month])

—>Use the 2nd varable to get the latest month data in the report

If you are getting null values for the month,filter that column by not null values

—>then use ranking to get the bottom 3 fields

check whether this solution works for your requirement.

Thanks,
Srinivas

srinivas_bo :india: (BOB member since 2007-05-03)

3

Hi Varsha,

First get the last Month

Create a Variable using if condition in webi which gives u the last Month e.gLast Month =If([Month] = MonthNumberOfYear(CurrentDate())-1) Then 1 Else 0

Now drag the last Month and filter by 1 and now you got the last Month data

Now click on add ranking
In Ranking Properties check the Bottom and enter 10 and rank by units.
Now click ok you will get the last Month with bottom 10 based on units always.

Thanks
Abid

abid.paul (BOB member since 2012-08-26)

4

thanks for ur reply,
i am donig that way only but is giving only latest month data value, i want all three months value in the table where ranking would be applied only on latest month and units will also be of latest month

varsha singh (BOB member since 2012-06-21)

5

Hi Varsha,

Please Explain it with Screen shots to understand the requirement in a better way.

Thanks,
Srinivas

srinivas_bo :india: (BOB member since 2007-05-03)

6

hi,
I had 12 months data value from that i have to show latest three months data value in webi and then apply rank to the latest month column. ex:-
unit march april may
oranges 38% -78% -
mangoes 40% 10% 9%
grapes 42% 17% 36%…so on

here when i am ranking the data is ranked based on summation of all three months while i want to rank based only on last month. like this:-
unit march april may
mangoes 40% 10% 9%
apple 30% 57% 14%
grapes 42% 17% 36%…

ok now can u ahelp me getting reqired output
thanks,
varsha

varsha singh (BOB member since 2012-06-21)