How to filter the data in charts

[#1]

hi,

i hv fields period with values jan 2004,feb.,...upto dec 2004

i hv chart to display the sum of sales when i click the field and i need the filter criteria to display feb and mar 2004 data alone.

thanks in advance

[#2]

HI,

use Set Analysis in your chart expression similar to this:

sum ( { $ <period= {'feb 2004', 'mar 2004'}> } sales)

Regards Roland

[#3]

Hi,

You can try as well to put one List box with year and another with month to filter the Date of your chart (you are fixing the dimension month/year). You can define as well the intervals in the list box that you want to filter your data. After that in your chart you only have to do a sum(sales).

Regards,

Joao