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