Good morning all. I'm working with Visual Analytics (now 6.4, soon 7.1) and I need your help. I need to create a filter on an aggregated measures to manage a simple threshold system. I mean: I have an aggregated measure created as AggM = Sum[_By_Group_](M1)/Sum[_By_Group_](M2), where neither M1 nor M2 are boolean measures, let's suppose with percentage format. I also have a geographic hierarchy (Region, Province, City) that I want putting on a map. So, when I run report I want to see AggM calculate for all region, then if I make a drill only provinces/ cities for which AggM > 30%. I solved the problem all regions --> some Provinces by means of Interaction, but I can't solve the question of showing only Provinces/Cities for whom percentage il more than a fixed value. Is anybody able to help me? Thanks a lot in advance!!!
... View more