Set analysis to stop drill down in Pie Chart

[#1]

HI,

I have  a pie chart with drill down option, in dimension (grouped) --> Geography-->Region, showing value of sales

When I drill down to Region the Pie should not allow me to further drill to single Region where Pie shows 100% for a single region. Rather it should start from Geo to region and stop at Region showing split %  all regions of particular Geo.

Please let me know how set analysis can be used.

Thanks,

Chanchal

[arjunkrishnan]

Pls Attach Your Qvw

[yduval75]

You can try :

if(getcurrentfield([hierarchicgroupname])='Region', Sum({<Region=>} Sales)

[lironbaram]

just use

sum({<Region=>}Sales)

this set analysis ignores selections made in the region field

how ever you should note the clicking on the chart will select a single region ,

so all other object will show other data then the pie chart

[#5]

Please find the qv file attached, if  you select Geo its flows to region and when you select region the selected region flows and pie shows as 100% for that selected region. I want that my selection should stop at at region &  should not flow to particular region.

[lironbaram · Accepted solution]

have a look at the attach qv

[#7]

Thanks Liron. Its helpful!!!