1 Reply Latest reply: Jun 19, 2015 5:12 AM by Amit Saini RSS

    top 10 positive top 10 negative values in bar chart

    Shashank Seth

      Hi Genuises,

       

      I am using the below formula as dimension and expression in chart

       

      dimension :

      =aggr(if(rank(num(Sum({<Description ={'Mubadala Opex'},LABEL={'BudgetUpdated'},YEARID = {$(=YearVariable)}>} AMOUNT*Sign) ,'#,##0;(#,##0)'))<=10

      or rank(-num(Sum({<Description ={'Mubadala Opex'},LABEL={'BudgetUpdated'},YEARID = {$(=YearVariable)}>} AMOUNT*Sign) ,'#,##0;(#,##0)'))<=10,DESCRIPTION),DESCRIPTION)

       

      Expression :

      =num(Sum({<Description ={'Mubadala Opex'},LABEL={'BudgetUpdated'},YEARID = {$(=YearVariable)}>} AMOUNT*Sign) ,'#,##0;(#,##0)')

       

      and in presentation Tab I am putting max visible number as 20 and checked so others label

       

      Now the problem is when I have 10 positive and 10 negative values in chart Others will show

       

      if lets say I have 10 positive and 5 negative values in chart then others are not showing instead it is clubbing everything as null "-" and displaying it

       

      I want to show it as Others

       

      Please please help I have to move this into production today

       

      Thanks in Advance

       

      Shashank