| rank [message #89401] |
Tue, 16 March 2004 02:21 |
Madhavi
Messages: 23
Registered: November 1999
|
Junior Member |
|
|
hi,
using rank function i have to get the data this way:
region is in the page item,
and the data points are :
year,sales,rank
1998,12347,2
1999,25345,3
2000,25364,1
so when i click on the region the ranking should change accordingly. and then if i drill on year the ranking should accordingly inthis way:
year sales,rank
1998 ,12347,2
Q1 1253,1
Q2 1254,2. now problem i m getting here is when im drilling on year it is showing the rank for that year as 0 and quarter the accordingly those ranks. pls help me the year should not change even i drill is this clear urgent!
madhavi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
