10 Replies Latest reply: Jun 30, 2015 10:51 AM by Chanty 4u RSS

    year quarter

    Chanty 4u

      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