How to show the part when i choose in the pie chart while not 100%?

[#1]

Hi,All

I thought that you have experienced the cucumstance in the pie chart

,

from the pie chart we know that 销售材料-饮料 is part values 22%.after I choose it ,it shows 100%,

how to make it shows its original data?

Thanks !

[Gysbert_Wassenaar]

Change your expression from something like sum(Amount) to sum({<PartDimension=>}Amount). The {<PartDimension=>} will make the pie chart ignore selections in the PartDimension dimension. Use the real field names that apply in your situation.

[mrossoit]

Hi,

uncheck Relative in Expression's tab and change your expression from

sum(your_field)

to

Sum(your_field)*100/sum(all your_field)

but doing this youll lose % simbol on right side of your values.

Regards

MR

[#4]

I texted.but it doesnot show as I wanted to be,I would like to express it detailed as follows.First statement.the left pie chart values classes,the right chart values name of materials,the left pie chart contains the right pie chart in level.

from the table we can see that 销售材料-蔬菜类 is 19.6% in the left pie chart ,when i click 生菜 in the right pie chart,the left pie chart show 100%,I want to let it show 19.6%,would it possible?

Thanks again

[#5]

I texted ,but It doesnot show the difference compare with before

[mrossoit]

Share your qvw, please

[#7]

Hi,

Following your first post I would suggest going to the obect's options: "Appearance" > "Presentation" > drop down menu - "Values".

However from the 2nd post I could suggest doing the same + creating a new "Drill-down" dimension, with the class of materials 1st and the names of materials as 2nd

.

Maybe this could be helpful, but to get the best solution it is really probably best to upload the qvw of your project, cheers