5 Replies Latest reply: Mar 14, 2016 10:18 AM by naveen kumar RSS

    how to display respective quarters

    naveen kumar

      HI,

       

      i am trying to display current and previous scores for each location  in a bar chart which i have done,

      expression :firstsortvalue(overall_src,-ADATE)(CURRENT )

                        firstsortvalue(overall_src,-ADATE,2) (PREVIOUS)

      But my client also need respective quarter with those scores,i thought it will be easy because i got quarter field ..and i added it as second dimension ....

      after adding that it is showing all the quarters for all location...

      what i need is only current and pervious quarters for all location