Help with Set Analysis

[Anonymous]

Hi

I have a field called 'Period' which represents financial reporting periods within a year and they are numbered 1 to 12. I want a chart to only show periods 1 to 6. What is the set analysis for this?

Thanks

[swuehl · Accepted solution]

{<Period = {">=1<=6"} >}

added to your expression's aggregation functions, like

=sum( {<Period = {">=1<=6"} >} Amount)