Limiting a Field in a Chart

[#1]

I am trying to make a chart based on a field in my database where I want to have the chart graph all records with a value of 70% or greater. I have tried the formula two ways the first in a calculated dimension then as an expression. In both cases I get an error in the calculation...=sum(Opportunity.Probability) > 70

Any Advice?

[Oleg_Troyansky]

You need to determine what dimension are you trying to limit by this condition, and use it in Set Analysis. For example, if you are counting OpportunityID with the sum(Probability) > 0.7 , you should have an expression like this:

count({<OpportunityID={"=sum(Opportunity.Probablility)>0.7"}>}  distinct OpportunityID)

Notice that your condition serves as a search condition for the field that you want to limit (OpportunityID in this example)