hi,
i have a drill report with the hierarchy Quarter->Month->Week->Day
in the report i am displaying four columns namely
Quarter,Ranking,CompanyName,Number of Prints
Here on clicking the Quarter(in the first column) it drills down to Month and then to Week and finally to Day.
Please see the attachment. i have explained it with an example.
i face an issue in the Ranking column because the ranking has to change based on the drill level.
That is when the drill is in Quarter, the Ranking column has to be 1,2,3,4,5
and when i drill down to month it should be 1,2,3 for January and again 1,2 for February
But now when i drill down to Month its still 1,2,3,4,5 only. How to split the ranking based on the drill level.
Please help me in this.
Ranking in drill report.xls (19.0 KB)
breeze_08 (BOB member since 2008-04-03)