Crosstab/Chart drill down Synchronization

[qvixote]

Hi, everybody!

I have crosstab and a pie chart related to the same query (DMR). In the crosstab, in rows there is TERRITORY dimension (country/state), then a dimension nested called CAUSE OF DEATH (my report is related to health), with 2 levels (group/cause). In the columns there's the Years, then nested the groups of age.

Then, I have the pie chart that uses Years as Categories, group of cause of death in the series and Count of Deaths as measure.

My problem is when I do drill down in the crosstab by territory, the pie chart dont reflect the change, so, when I'm in the first level (country) the pie chart shows numbers for country, but when I'm in state level, the pie shows the same numbers.

Hos can I synchronize these two element if I'm not using terrotory in the pie chart?

[MFGF]

Hi,

Go to your query and try dragging the Country set into the Slicer area. Does this give you what you need?

Cheers!

MF.

[qvixote]

Hi, MFGF!

I dragged the Country set to the Slicer area and it did not work.

Thanks any way.

[MFGF]

...it did not work...

Hi,

What result did you get? An error? Different numbers than you expected? No change when you drill down?

MF.

[qvixote]

Oh, sorry. No change, the pie chart keeps showing the totals without changing when drilling in the table.

[MFGF]

Weird! I tried this with the sample GO Sales (Analysis) package and it appeared to work ok for me. Are the crosstab and the chart definitely sharing the same query?

[gfarrell]

I had the same issue. When you create the two separate objects they will have a different query. ie Crosstab = Query 1 and Chart = Query 2. Change the chart to use query 1 in the properties. Now when you drill on the cross tab the chart will also drill down.