Filtering values yet retaining original %s

[mattphillip]

Hoping someone can help. I have a bar chart counting the five different numerical values (1-5) within a field. What I'd like to do, and so far have not managed to succeed in doing is to limit the visible fields (for example, values 1 and 2 only) but to retain their original % based on the complete set of five values not the revised total based on the two displayed values.

The expression I've tried is: =sum([SIMD Quint)/sum(TOTAL [SIMD Quint]) with the relative option selected.

Is this achievable?

Any help would be much appreciated.

Matt

[tresesco]

Not sure if got your point right. Maybe you can try something like:

=sum({< [SIMD Quint]={1,2}>}[SIMD Quint])/sum(TOTAL [SIMD Quint])

[#3]

Hi Matt,

I think you want to use set analysis on the total section of your expression, so that each SIMD Quint is calculating from the field total. Try the below

sum([SIMD Quint])/sum({<[SIMD Quint]=>}TOTAL [SIMD Quint])

hope that helps

Joe

[mattphillip]

Thanks guys! I tried both and it almost worked. When I combined both it worked fully.

sum({< [SIMD Quint]={1,2}>}[SIMD Quint])/sum({<[SIMD Quint]=>}TOTAL [SIMD Quint])

Many thanks!

M

[#5]

Hi Matt,

ah I thought the 1&2 was just an example of what you might select down to, not the specific limit you wanted, glad that's working for you now