Drill down with chart

[neskin]

Hi,
I have create a advanced bar chart 'on change of'formula @RMT_Label and 'show' 2 values night and day for RMT.
If I create group bar chart and show 1 value i can drill down .How to drill down on advanced bar chart?
I am using crystal XI
thank you in advance

 

[eo]

Have to you tried to create groups, hide those groups, and base the bars on the group level summaries?

EO
Hertfordshire, England

 

[neskin]

I have created group RMT_label and hided them I can not base the bar on the group.I need to show 2 bars(night and day ) for one RMT and then once they click on one of the bar for RMT1 will drill down for the details

 

[eo]

Without more detailed information on your data, this is pretty much all guess work. But here goes:

Create a formula distinguishing between night and day: {@day_night}

If {RMT_Label} = xxx then 'night' else 'day'

Now group by {@day_night}, and hide the data.
Do your necessary summaries.
Now create a chart in RH band based on on change of {@day_night}--thgis will create 2 bars (as you stated you needed), and should create a drill down to the data of either day or night.



EO
Hertfordshire, England

 

[neskin]

ok let me give your more info
the report based on stored procedure which returns rmtid
and night ,day
rtmid night day
1 20 10
2 30 10
....
the chart shows bars 'on change of'formula @RMT_Label and 'show' night and day values.I need to drill down by clicking on bar or on rmt_label (axis x)to show more details
I fogot to mention i also have cross tab
rmt_label 1 2
night 20 30
day 10 10

the drill down could be done on cross tab either way will do
thank you