1 2 Previous Next 29 Replies Latest reply on Oct 15, 2013 7:05 AM by Jonathan Drummey

    How to get top 3 sales country based on max week in line trend

    Rajini S

      Hi All,

       

      I am facing issue to get top countries based on maximum week in a line trend chart. Ex. I have data for wk 32, 33, 34 and need to get top 3 sales countries based on maximum week and those top 3 countries need to display to the entire weeks. Here, wk 34 is maximum week and CN, FR, UAE are top 3 countries and these 3 will display as 3 lines in the chart for entire weeks. Attached sample report.

       

      I have created calculated field 'Sort' and set top 3 in Country filter by Sort field.

      Sort = if [Week]='2013 W34' then [Sales] else null end

       

      I have hard coded W34 in Sort field but it has to remove and to set condition to get max week by default.

      How can get top 3 sales country based on max week by default?

       

      Best Regards,

      Rajini

        1 2 Previous Next