Bar chart with different type of data structure

[kennethand]

I like to make a bar chart showing the distribution (sum to 100%) of The Residence out of where people consider to live.

This is a snip off my data (every ID has a weight):

ID	Community	Parameter
2018_4_1	A	Consider
2018_4_1	B	Residence
2018_4_100	A	Consider
2018_4_100	B	Consider
2018_4_100	C	Residence
2018_4_1016	D	Consider
2018_4_1016	D	Residence
2018_4_114	A	Consider
2018_4_114	D	Residence
2018_4_1190	B	Consider
2018_4_1190	C	Consider
2018_4_1190	D	Residence

ID	Weight
2018_4_1	0,651951
2018_4_100	1,126967
2018_4_1016	1,355012
2018_4_114	0,553152
2018_4_1190	1,868304

I have a filter pane with 'Community' and if I fx. choose 'A' I like to show bar chart showing:

I need to sum the weight using disinct ID of who is considering 'A' and calculate the % out of them distributed per residence.

The challenge is the way the data is structured. 

Is it somehow possible to solve this using the right expression?

[lfetensini]

If you need fix Community A:

Sum(
{<
Community = {'A'}
>}
Weight
)

If incorrect, print and show your load script and Internal View Tables for a better understanding of your case