Hi guys,
i have year and yearquarter field
one pie chart one bar chart with sum(sales)
so my requiremment is wenever i clear all it wil display the max year higest quarter value for that what can i do
can anyone give me the suggestions.
my fileds
year yearquarter
2000 2000Q1,2000Q2,2000Q3,2000Q4
2001 2001Q1,2001Q2,2001Q3,2001Q4
2002 2002Q1,2002Q2,2002Q3,2002Q4
2003 2003Q1,2003Q2,2003Q3,2003Q4
result wil be lik
display 2003Q4 sales.
Thank you
Suresh
