Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
=Sum({$<[Location]= {"USA"}, FieldName = {'Condition'}>}Value)/Sum({$<[Location]= {"USA"}, FieldName = {'Condition'}>} TOTAL <[Title role]> Value)
This??
sum({$<[Location]= {"USA"}> }Value) / sum(total {$<[Location]= {"USA"}> } <[Title role]> Value)
Or This
sum({$<[Location]= {"USA"}> }Value) / sum(total <[Title role]> Value)
May be like this:
=Sum({$<[Location]= {"USA"}, FieldName = {'Condition'}>}Value)/Sum({$<[Location]= {"USA"}, FieldName = {'Condition'}>} TOTAL <[Title role]> Value)
Thanks! You have been a great help