Filters on a 100%stacked bar

[Anonymous]

Hi,

I created a 100% stacked bar using the below formula:

sum( Value) /sum(total <[Title role]> Value)

I now need to apply filters on other dimension to select a particular value for the chart.

sum(=sum({$<[Location]= {"USA"}> }Value) / sum(total <[Title role]> Value) but this does not provide correct values.

i need to apply filters in 2 different dimensions like this but i am not able to figure out.

Any help is much appreciated. Thanks

[Anil_Babu_Samineni]

This??

sum({$<[Location]= {"USA"}> }Value) / sum(total {$<[Location]= {"USA"}> } <[Title role]> Value)

[Anil_Babu_Samineni]

Or This

sum({$<[Location]= {"USA"}> }Value) / sum(total <[Title role]> Value)

[sunny_talwar · Accepted solution]

May be like this:

=Sum({$<[Location]= {"USA"}, FieldName = {'Condition'}>}Value)/Sum({$<[Location]= {"USA"}, FieldName = {'Condition'}>} TOTAL <[Title role]> Value)

[Anonymous]

Thanks! You have been a great help