Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
use Set Analysis in your chart expression similar to this:
sum ( { $ <period= {'feb 2004', 'mar 2004'}> } sales)
Regards Roland
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