how to make pie chart show proportion of selected values in total including unselected

[#1]

Hi.

Sorry for the lengthy subject (which may sound stupid to many). A newbie here and I think I am doing something wrong. My problem is that I couldn't make the pie chart show the correct proportion of the selected values in the total. I am attaching screenshots to better explain my problem. The first image which shows all the values is okay. However, if I select values from the 'WATER_DESC" field list, the pie chart shows total only of the selected values. What I want to achieve is to get the proportion of the selected values in the total number of respondents.

Thanks and cheers.

[#2]

Hi,

May I know your expression? How is it look like? Under expressions tab, did you check the relative box?

Regards,

Janzen

[#3]

Hi, Janzen.

Thanks for responding. Yes, I checked the relative box. But it seems that it is only computing against the total number of respondents of the selected values not of the entire number of respondents...