Drill Down Bar charts to Pie chart

[#1]

Hi

I would like to have an example in which the actual data is expressed in a bar char, On clicking the bar, I would like to drill it down to PIE chart. Any help on this ? URGENT pls.

[jagan · Accepted solution]

Hi,

Please find attached file solution.  Check Layout tab->Display Conditional section.

Regards,

Jagan.

[parthiband]

Its Working!!

Thanks

[nizamsha]

first of all u have to creat a bar and pie chart with the same dimension and measure

after creating the two seprate chart go to any one of the chart in the layout tab enable the condition in that write these condition getselectedcount(year)=0 in pie chart and also

write these in getselectedcount(year)>0 in bar chart if u click any one of the chart it will disable the current chart and enable the next one go for it ..it will work